sysindexes

  • SELECT * FROM sysindexes and ı get that error Msg 7105, Level 22, State 6, Line 1

    Page (1:288), slot 1 for text, ntext, or image node does not exist.

    I try DBCC CHECKDB and DBCC CHECKTABLE all of version what can I do?

  • What is the result of

    DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS

  • Server: Msg 8939, Level 16, State 5, Line 1

    Table error: Object ID 0, index ID 0, page (1:288). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.

    Server: Msg 8939, Level 16, State 1, Line 1

    Table error: Object ID 0, index ID 0, page (1:288). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.

    Server: Msg 8939, Level 16, State 1, Line 1

    Table error: Object ID 0, index ID 0, page (1:288). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.

    Server: Msg 8929, Level 16, State 1, Line 1

    Object ID 2: Errors found in text ID 22151168 owned by data record identified by RID = (1:24:3) id = 2 and indid = 1.

    Server: Msg 8929, Level 16, State 1, Line 1

    Object ID 2: Errors found in text ID 65536 owned by data record identified by RID = (1:24:5) id = 3 and indid = 1.

    Server: Msg 8929, Level 16, State 1, Line 1

    Object ID 2: Errors found in text ID 23855104 owned by data record identified by RID = (1:243:0) id = 78623323 and indid = 2.

    Server: Msg 8929, Level 16, State 1, Line 1

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

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