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'. [SQLSTATE 01000]
When the errors started happening I would run
dbcc checktable
on the two tables in the error msg and always receive the following
DBCC results for 'FinlAvgCalc2'.
There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
with no errors reported.
Any additional ideas would be greatly appreciated.
Thanks
Dan