Tag: SQL Server Errors

SQL Server Error Msg 5064 – Changes to the state or options of database ‘%.*ls’ cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

SQL Server Error Msg 20699 – A value for the parameter @suser_sname was not specified while publication uses SUSER_SNAME() for dynamic filtering.

SQL Server Error Msg 3457 – Transactional file system resource manager ‘%.*ls’ failed to recover. For more information, see the accompanying error message, which determines the appropriate user action.

SQL Server Error Msg 3976 – The transaction name has the odd length %d. The batch has been aborted.

SQL Server Error Msg 7354 – The OLE DB provider “%ls” for linked server “%ls” supplied invalid metadata for column “%ls”. %ls

SQL Server Error Msg 28045 – Connection handshake failed. The certificate used by the peer does not match the one in MASTER database with same issuer name and serial number. State %d.

SQL Server Error Msg 46646 – provided

SQL Server Error Msg 9516 – XQuery: The name or one of the parts of a multi-part name supplied to %S_MSG(‘%.*ls’) is empty. Empty names cannot be used to identify objects, columns or variables in SQL.

SQL Server Error Msg 6513 – Failed to initialize the Common Language Runtime (CLR) %ls due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online.

SQL Server Error Msg 22582 – Article ‘%s’ cannot be added or modified in publication ‘%s’. The replication of FILESTREAM columns is not supported for publications that have a ‘publication_compatibility_level’ of less than “90RTM” (SQL Server 2005). Specify a ‘publication_compatibility_level’ greater than or equal to “90RTM” by using sp_addmergepublication or sp_changemergepublication, or partition the article vertically so that the FILESTREAM column is not replicated.

SQL Server Error Msg 35435 – system database

SQL Server Error Msg 13015 – spatial index operations

SQL Server Error Msg 7396 – Varchar(max), nvarchar(max), varbinary(max) and large CLR type data types are not supported as return value or output parameter to remote queries.

SQL Server Error Msg 14826 – Update and delete of rows eligible for migration in table ‘%.*ls’ is not allowed because of the use of REMOTE_DATA_ARCHIVE.

SQL Server Error Msg 8509 – Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: %ls.

SQL Server Error Msg 8199 – In EXECUTE , procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.

SQL Server Error Msg 18124 – The default collation was successfully changed.

SQL Server Error Msg 30027 – The full-text index is in an inconsistent state because the search property list of the full-text index was reconfigured using the WITH NO POPULATION clause. To bring the full-text index into a consistent state, start a full population using the statement ALTER FULLTEXT INDEX ON START FULL POPULATION;. This is a warning. No user action is necessary.

SQL Server Error Msg 28013 – The service broker is administratively disabled.

SQL Server Error Msg 2512 – Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). Duplicate keys on page %S_PGID slot %d and page %S_PGID slot %d.