Post reply

Error: 3624, Severity: 20, State: 1

  • September 15, 2006 at 9:19 am

    #114573

    In one of the production SQL 2000 server, I am receiving below two errors continuously in 10 minutes interval in NT Event Viewer.

     

    17066 :

    SQL Server Assertion: File: <insert.c>, line=573

    Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.

     

      

    18052 :

    Error: 3624, Severity: 20, State: 1.

     

    Could any one please guide me how to resolve these errors?

    Thanks for your help.


    CDBA

  • September 16, 2006 at 1:45 pm

    #660893

    try to run

    DBCC CHECKDB

    and then

    DBCC CHECKTABLE

     which provided more details to

    troubleshoot the error

    --

    When did you run  DBCC DBREINDEX last time?

  • September 16, 2006 at 2:11 pm

    #660896

    I got this server only 3 days back under me and I dnot think that anyone executed dbcc on the box.

    But the applications/dts are working fine on the box. Still u suggest for a reindexing? Plz suggest


    CDBA

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

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