SQL Server Errors or Failures from Error: 7970 to Error: 7994

SQLServerF1

 

Error: 7970, Severity: 10, %hsOldest active transaction:
Error: 7971, Severity: 10, SPID (server process ID): %d%s
Error: 7972, Severity: 10, UID (user ID) : %d
Error: 7974, Severity: 10, Name : %.*ls
Error: 7975, Severity: 10, LSN : (%d:%d:%d)
Error: 7977, Severity: 10, Start time : %.*ls
Error: 7978, Severity: 10, SID : %.*ls
Error: 7979, Severity: 10, %hsReplicated Transaction Information:

Error: 7980, Severity: 10, Oldest distributed LSN : (%d:%d:%d)
Error: 7982, Severity: 10, Oldest non-distributed LSN : (%d:%d:%d)
Error: 7983, Severity: 14, User ‘%.*ls’ does not have permission to run DBCC %ls for database ‘%.*ls’.
Error: 7984, Severity: 16, System table pre-checks: Object ID %d. Page %S_PGID has unexpected page type %d. Check statement terminated due to unrepairable error.
Error: 7985, Severity: 16, System table pre-checks: Object ID %d. Could not read and latch page %S_PGID with latch type %s. Check statement terminated due to unrepairable error.
Error: 7986, Severity: 16, System table pre-checks: Object ID %d has cross-object chain linkage. Page %S_PGID points to %S_PGID in alloc unit ID %I64d (should be %I64d). Check statement terminated due to unrepairable error.

Error: 7987, Severity: 16, System table pre-checks: Object ID %d has chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->prev = %S_PGID. Check statement terminated due to unrepairable error.
Error: 7988, Severity: 16, System table pre-checks: Object ID %d. Loop in data chain detected at %S_PGID. Check statement terminated due to unrepairable error.
Error: 7989, Severity: 16, Checking identity information: current identity value ‘%.*hs’.
Error: 7992, Severity: 16, Cannot shrink ‘read only’ database ‘%.*ls’.
Error: 7993, Severity: 10, Cannot shrink file ‘%d’ in database ‘%.*ls’ to %u pages as it only contains %u pages.
Error: 7994, Severity: 10, DBCC CheckDatabase on resource database will be skipped because user ‘%.*ls’ does not have permission.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

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