Tag: SQL Server Errors

SQL Server Error Msg 1019 – Invalid column list after object name in GRANT/REVOKE statement.

SQL Server Error Msg 35253 – Database “%.*ls” is not in the correct state to become the primary database.  The log must be restored from the previous primary replica to bring the database out of the reinitializing state.

SQL Server Error Msg 40301 – Invalid lock mode or resource received in lock request.

SQL Server Error Msg 8542 – Spid %d tried to commit the distributed transaction with UOW %ls.

SQL Server Error Msg 2598 – Check cannot proceed on any objects belonging to database “%.*ls” because it is currently in recovery.

SQL Server Error Msg 30108 – Invalid matrix guid.

SQL Server Error Msg 21722 – Failed to add an extended trigger for replicating the ‘%.*ls’ event.

SQL Server Error Msg 14849 – Attempted Migration failed. Remote insert failed to insert all the rows. Expected rows : %d, Actual remote rows inserted: %d.

SQL Server Error Msg 7650 – Warning: Failed to drop full-text catalog at ‘%ls’.

SQL Server Error Msg 21544 – Value specified for the publication property replicate_ddl is not valid. The value must be 1 or 0.

SQL Server Error Msg 47124 – Creation of contained availability group master database failed. Only contained availability group can create contained availability group master database. Verify availability group availability options are correct, then retry the operation.

SQL Server Error Msg 6851 – Column ‘%.*ls’ has invalid data type for attribute-centric XML serialization in FOR XML PATH.

SQL Server Error Msg 1220 – No more lock classes available from transaction.

SQL Server Error Msg 1727 – Cannot create non-clustered index ‘%.*ls’ on table ‘%.*ls’ with the FILESTREAM_ON clause.

SQL Server Error Msg 8918 – (number of mixed extents = %I64d, mixed pages = %I64d) in this database.

SQL Server Error Msg 46530 – External data sources are not supported with type %S_MSG.

SQL Server Error Msg 33075 – Granular auditing is not available in this edition of SQL Server. For more information about feature support in the editions of SQL Server, see SQL Server Books Online.

SQL Server Error Msg 1487 – Database mirroring is starting %d parallel redo thread(s) with database ‘%.*ls’ as the mirror copy. This is an informational message only. No user action is required.

SQL Server Error Msg 10111 – Cannot create %S_MSG on view “%.*ls” because it contains a join using an ODBC standard escape syntax. Consider using an ANSI join syntax instead.

SQL Server Error Msg 29260 – Configuration manager cannot set matrix state.