Integrity check getting an error

  • [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8964: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1092), slot 46, text ID 4243624165376 is not referenced.

    The following errors were found:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1092), slot 46, text ID 4243624165376 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1104), slot 67, text ID 4243759693824 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1105), slot 78, text ID 4243806748672 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:18458), slot 7, text ID 4243624689664 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:18460), slot 9, text ID 4243629801472 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:22818), slot 8, text ID 4243821297664 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:22820), slot 5, text ID 4243699662848 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:50517), slot 9, text ID 4243626262528 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:50518), slot 13, text ID 4243702022144 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:60078), slot 7, text ID 4243702415360 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:60079), slot 12, text ID 4243629015040 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:207161), slot 11, text ID 4246428188672 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:207161), slot 24, text ID 4246429892608 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:207161), slot 37, text ID 4246431596544 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:207161), slot 50, text ID 4246433300480 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:207161), slot 51, text ID 4246433431552 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:207161), slot 52, text ID 4246433562624 is not referenced.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Too many errors found (201) for object ID 1136059133. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".

    [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 20267 consistency errors in table 'Base_CatalogProducts' (object ID 1136059133).

    [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 20267 consistency errors in database 'cdi_commerce'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (cdi_commerce ).

  • Please don't double post!

    For those who are going to look deeper into this issue, answers already started at thread http://www.sqlservercentral.com/Forums/FindPost681150.aspx

    Edit: link added



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply