• 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