SQL Error : Msg 427, Level 20, State 1, Line 1 Could not load the definition for constraint ID %d in database ID %d. Run DBCC CHECKCATALOG to verify the integrity of the database.

Leave a comment (0) Go to comments

SQL Server Error Message:

"Msg 427, Level 20, State 1, Line 1 Could not load the definition for constraint ID %d in database ID %d. Run DBCC CHECKCATALOG to verify the integrity of the database."

What and Why "this Error":

This error occurs when a Microsoft SQL Server finds a problem with a statement issued by the current process. This could be because of many reasons like :

  • File level corruption
  • Statement tried to access a corrupted page
  • Current statement tried to find record on missing or corrupted page/record/file/index
  • Statement tried to access a corrupted table / index

Action Required to resolve this Error:

You need to check database consistency to confirm there is no corruption in the database by running statements

DBCC CHECKCATALOG , DBCC CHECKTABLE and DBCC CHECKDB

If the index is corrupted, rebuild the index

Note:

  1. Severity level 20 indicates a problem with a statement issued by the current process.
  2. %d, %ld, or %D means Decimal integer value
    %x means Hexadecimal number value
    %ls or %.*ls means Character string value
    %S_type means SQL Server -defined structure value
    %c means Single character value
    %lf means Double floating-point number value
EOF - SQL Error : Msg 427, Level 20, State 1, Line 1 Could not load the definition for constraint ID %d in database ID %d. Run DBCC CHECKCATALOG to verify the integrity of the database., SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.