October 11, 2004 at 10:02 am
We have a DB maintenance plan created with wizard. And recently it just started failing with following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 181575685. The text, ntext, or image node at page (1:81), slot 0, text ID 36651859968 is referenced by page (1:97), slot 0, but was not seen in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 181575685. The text, ntext, or image node at page (1:82), slot 0, text ID 36651859968 is referenced by page (1:97), slot 0, but was not seen in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Obje
Does anybody know what could be a cause of that? Or may be had this error before? Thanks in advance for any help. I need it ASAP.
October 11, 2004 at 10:47 am
First find out what table has the error:
select object_name(181575685)
You will need to run this for the correct database. You may be able to see which database was being checked by looking through the log.
After you find the table in question run dbcc checktable('tablename')
This will give you information about the problem.
You will then need to run DBCC checktable with one of the repair options.
October 11, 2004 at 12:01 pm
Unfortunately it did not give me much info either. Here is what i've got
DBCC results for 'CDATA'.
There are 255 rows in 10 pages for object 'CDATA'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply