Error 8986

Troubleshooting SQL Server

Troubleshooting

Error 8986

Severity Level 16
Message Text

Too many errors found (%d) for object ID %d. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".

Explanation

As the text for messages on this object from checkdb is printed, the limit for the maximum number of errors that will be reported on a given object has been exceeded. Currently, that hard-coded limit is 200.

Action

You can specify the additional statement "WITH ALL_ERRORMSGS" to get a complete listing of errors for the object in question.