I have run DBCC CHECKDB (Which says it does everything DBCC CHECKALLOC does) and still have the 18 consistancy errors.
Here is one of them:
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 512720879. The text, ntext, or image node at page (1:148261), slot 13, text ID 25402474496 is not referenced.
My opinion is that the text pointer is messed up. I have been trying to find the rows that have a problem. Is there anyway the above info in the error can help me find the rows where the problem exits. I know how to use the first ID (it references an object in sysobjects - in this case a table).
What about the text ID? Should I be able to find that in a system table somewhere?
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems