Tag: SQL Server Errors

SQL Server Error Msg 37106 – The database ‘%.*ls’ on server ‘%.*ls’ is in use by job account ‘%.*ls’. The database cannot be deleted or renamed while associated with a job account.

SQL Server Error Msg 8566 – Unable to commit a prepared transaction from the Microsoft Distributed Transaction Coordinator (MS DTC). Server will restart the database and MS DTC recovery is expected to resolve any in-doubt transaction.

SQL Server Error Msg 21780 – The non-SQL Server Publisher is missing one or more %s objects. Drop and re-create the Publisher and the replication administrative user schema.

SQL Server Error Msg 25020 – The article cannot be created on table ‘%s’ because it has more than %d columns and column-level tracking is being used. Either reduce the number of columns in the table or change to row-level tracking.

SQL Server Error Msg 5803 – Unknown configuration (id = %d) encountered in sys.configurations.

SQL Server Error Msg 27032 – Error Tolerant Index Metadata string too long.  Index is probably corrupt.

SQL Server Error Msg 32046 – Only members of the sysadmin fixed server role or the ‘dbm_monitor’ role in msdb can perform this operation.

SQL Server Error Msg 5219 – %.*ls: Heap page %d:%d could not be moved.

SQL Server Error Msg 7931 – Database error: The FILESTREAM directory ID %.*ls for a partition was seen two times.

SQL Server Error Msg Max length literals not supported in %S_MSG. – 16

SQL Server Error Msg 21812 – Cannot perform “Disable Trigger All” on table %s because it belongs to a publication that supports updatable subscriptions (replication adds triggers to tables for these types of publications). You may, however, disable user triggers individually. Specify an individual user trigger name to disable.

SQL Server Error Msg 21249 – OLE DB or ODBC Subscribers cannot subscribe to article ‘%s’ in publication ‘%s’ because the article has a timestamp column and the publication is ‘allow_queued_tran’ (allows queued updating subscriptions).

SQL Server Error Msg 3036 – The database “%ls” is in warm-standby state (set by executing RESTORE WITH STANDBY).

SQL Server Error Msg 12619 – The database has too long file path to create clone.

SQL Server Error Msg 9524 – The XML content provided does not conform to the required XML format for sparse column sets.

SQL Server Error Msg 14101 – The publication ‘%s’ already has a Snapshot Agent defined.

SQL Server Error Msg 32007 – Database %s is not ONLINE.

SQL Server Error Msg 27054 – Maintenance trigger already installed on this reference table.

SQL Server Error Msg 6370 – MAX_LENGTH option is not allowed in combination with ‘node()’ for selective XML index ‘%.*ls’.

SQL Server Error Msg 8603 – Invalid syntax for internal DBCC REPAIR statement.