Post reply

error Msg 2511 in sql server

  • September 20, 2005 at 8:52 am

    #110015

    Hi all,

    When i am running dbcc on my database , i am receiving following error.

     

    Server: Msg 2511, Level 16, State 2, Line 1

    Table error: Object ID 341576255, Index ID 0. Keys out of order on page (3:215815), slots 31 and 32.

     

    anybody has any idea about it? Thanx in advance.

  • September 20, 2005 at 5:37 pm

    #591552

    You probably have a corrupt index in the database.  Drop and recreate the indexes to fix.

    Greg

    Greg

  • September 20, 2005 at 8:11 pm

    #591564

    Hi Nikil,

    Run this commnd to to see the exact erro.

    DBCC checktable tablename

    if u have a currupt index just drop it and recreate it.

     

    hope this help u

    from

    KIller

  • September 21, 2005 at 8:00 am

    #591773

    Thank you very much for your reply.

    I already run dbcc checktable command and i found one of my table currupted. so drop clustered index and recreated it. now its workd absolutely fine.

    Thanks again.

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

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