Results 1 to 2 of 2

Thread: Table corrupt error 2511 SQL 6.5

  1. #1
    charles Guest

    Table corrupt error 2511 SQL 6.5

    I have the following error on a table. I have rebuilt the index with the sorted_DATA_reorg option but no sucess any ideas!!?

    Table Corrupt: Keys in data page should be in ascending order; check page number 13843
    Server: Msg 2511, Level 16, State 1, Line 1

  2. #2
    Satya SK Jayanty Guest

    Table corrupt error 2511 SQL 6.5 (reply)

    use DBCC CHECKTABLE (table_name [, NOINDEX | index_id])
    It checks the specified table to see that index and data pages are correctly linked, that indexes are in proper sorted order, that all pointers are consistent, that the data information on each page is reasonable, and that page offsets are reasonable.

    If the log segment is on its own device, running DBCC CHECKTABLE on the syslogs table reports the log's used and free space.

    If an index_id is specified, CHECKTABLE will check only that index.

    Cheers
    --Satya

    ------------
    charles at 6/1/01 6:33:28 AM

    I have the following error on a table. I have rebuilt the index with the sorted_DATA_reorg option but no sucess any ideas!!?

    Table Corrupt: Keys in data page should be in ascending order; check page number 13843
    Server: Msg 2511, Level 16, State 1, Line 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •