Tag: MS SQL Server Error Codes

SQL Server Error Code – 971 the resource database has been detected

In this blog post, you’ll learn more about the SQL Server Error Code 971 and the error message description that is shown SQL Server Error Code 971 SQL Server Error Description for the Code :971 The resource database has been detected in two different locations. Attaching the resource database in the same directory as sqlservr.exe at ?%.*ls? instead of the currently attached resource database at…

SQL Server Error Code – 21747 cannot establish a connection to the ora

In this blog post, you’ll learn more about the SQL Server Error Code 21747 and the error message description that is shown SQL Server Error Code 21747 SQL Server Error Description for the Code :21747 Cannot establish a connection to the Oracle Publisher ‘%s’. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS.

SQL Server Error Code – 8909 table error: object id %d, index id %d,

In this blog post, you’ll learn more about the SQL Server Error Code 8909 and the error message description that is shown SQL Server Error Code 8909 SQL Server Error Description for the Code :8909 Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page ID %S_PGID contains an incorrect page ID in its page header. The…

SQL Server Error Code – 1467 database ?%.*ls? database is in emergenc

In this blog post, you’ll learn more about the SQL Server Error Code 1467 and the error message description that is shown SQL Server Error Code 1467 SQL Server Error Description for the Code :1467 Database ?%.*ls? database is in emergency or suspect mode on one of the partners which is incompatible with participating in database mirroring or in an availability group.

SQL Server Error Code – 1762 cannot create the foreign key ?%.*ls? wi

In this blog post, you’ll learn more about the SQL Server Error Code 1762 and the error message description that is shown SQL Server Error Code 1762 SQL Server Error Description for the Code :1762 Cannot create the foreign key ?%.*ls? with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.

SQL Server Error Code – 7879 sql server is waiting for %d remaining s

In this blog post, you’ll learn more about the SQL Server Error Code 7879 and the error message description that is shown SQL Server Error Code 7879 SQL Server Error Description for the Code :7879 SQL Server is waiting for %d remaining sessions and connections to close. If these sessions are not closed within a reasonable amount of time, “polite” shutdown will be aborted. This…