Tag: SQL Server Errors

SQL Server Error Msg CREATE DATABASE failed. Recollating the database failed while creating the partially contained database ‘%.*ls’, with a default data collation of ‘%.*ls’. – 16

SQL Server Error Msg 8387 – The indirect application of table hints to an invocation of a multi-statement table-valued function (TVF) through a view will be removed in a future version of SQL Server. Remove hints on references to view “%.*ls” because it references a multi-statement TVF.

SQL Server Error Msg 684 – An internal error occurred while attempting to convert between compressed and uncompressed storage formats.  Run DBCC CHECKDB to check for any corruption.

SQL Server Error Msg 21839 – Article ‘%s’ can not support schema_option 0x20 or 0x2000000000 because it contains computed column, check/default constraint or primary key which is based on CLR type column, change @schema_option setting and try again.

SQL Server Error Msg 2707 – Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it depends on a non-schemabound object.

SQL Server Error Msg 20019 – Replication database option ‘%s’ cannot be set unless the database is a publishing database or a distribution database.

SQL Server Error Msg 17120 – SQL Server could not spawn %s thread. Check the SQL Server error log and the operating system error log for information about possible related problems.

SQL Server Error Msg 3608 – Cannot allocate a GUID for the token.

SQL Server Error Msg 4164 – A GROUP BY clause in a PROB_MATCH query can only have key columns, and needs to include all the key columns.

SQL Server Error Msg 40817 – Could not change database edition from Premium for a database in a replication relationship.

SQL Server Error Msg 41388 – An upgrade operation failed for database ‘%.*ls’. Check the error log for additional details.

SQL Server Error Msg 9447 – XML parsing: line %d, character %d, entity content not well formed

SQL Server Error Msg 1973 – Cannot perform the specified operation on disabled index ‘%.*ls’ on %S_MSG ‘%.*ls’.

SQL Server Error Msg 10081 – The rowset uses integrated indexes and there is no current index.

SQL Server Error Msg 6966 – Warning: Type ‘%s’ is restricted by a facet ‘%s’ that may impede full round-tripping of instances of this type

SQL Server Error Msg 45306 – The external admin cannot be set because the user or group already exists in the ‘master’ database.

SQL Server Error Msg 5552 – FILESTREAM file named with GUID ‘%.*ls’ that belongs to FILESTREAM data file ID 0x%x does not exist or cannot be opened.

SQL Server Error Msg 6321 – xml:space attribute must have a value of ‘preserve’ or ‘default’.  ‘%.*ls’ is not valid.

SQL Server Error Msg 8007 – The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter %d (“%.*ls”): The chunking format is incorrect for a large object parameter of type 0x%02X.

SQL Server Error Msg 27037 – No table name provided for Error Tolerant Index.  The index is probably corrupt.