That being the case any idea as to why then the DBCC DBREINDEX is failing to start with?

I was under the impression that the DBCC DBREINDEX was rebuilding the indexes?

Allen

Thanks for the response. Once a week I run

DBCC CHECKDB (@dbname) WITH ALL_ERRORMSGS

and I get the following result

CHECKDB found 0 allocation errors and 0 consistency errors in database 'SNLEDIT'....