Tag: SQL Server Errors

SQL Server Error Msg The column referenced as ‘%.*ls’ resolves differently in the target metadata collation ‘%.*ls’ than in the current metadata collation ‘%.*ls’. – 16

SQL Server Error Msg 20524 – Table ‘%s’ may be out of synchronization. Rowcounts (actual: %s, expected: %s). Rowcount method %d used (0 = Full, 1 = Fast).

SQL Server Error Msg 33156 – A Federated Authentication token was sent by the client when the server is not expecting it. So server will close the connection due to TDS non-conformance.

SQL Server Error Msg 21450 – The replication %s could not be upgraded for %s databases. Ensure that %s is upgraded and execute %s again.

SQL Server Error Msg 45120 – The name ‘%ls’ already exists. Choose a different name.

SQL Server Error Msg 40645 – Servername “%.*ls” cannot be empty or null. It can only be made up of lowercase letters ‘a’-‘z’, the numbers 0-9 and the hyphen. The hyphen may not lead or trail in the name.

SQL Server Error Msg 40877 – The elastic pool is not empty.

SQL Server Error Msg 7008 – The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.

SQL Server Error Msg 11717 – NEXT VALUE FOR function does not support the OVER clause in default constraints, UPDATE statements, or MERGE statements.

SQL Server Error Msg 15040 – User-defined error messages must have an ID greater than 50000.

SQL Server Error Msg 16605 – Member database ‘%ls’ is invalid.

SQL Server Error Msg 17408 – The automatic soft-NUMA configuration has been set to ‘%S_MSG’. Restart SQL server for the new setting to take effect.

SQL Server Error Msg 47109 – Availability group ‘%.*ls’ cannot failover to this replica. Configuration-only replica cannot become primary. An attempt to fail over an availability group failed. The replica is a configuration-only and cannot become a primary.

SQL Server Error Msg 13197 – Certificate expired

SQL Server Error Msg 6575 – Assembly names should be less than %d characters. Assembly name ‘%.*ls’ is too long.

SQL Server Error Msg 14111 – The @pre_creation_cmd parameter value must be ‘none’ or ‘drop’.

SQL Server Error Msg 40065 – CSN vector can be reinitialized only with initial or invalid CSN. The new CSN is (%d,%I64d), the current CSN is (%d,%I64d).

SQL Server Error Msg 7991 – Clustered columnstore index ‘%.*ls’ on table ‘%.*ls’ has a missing dictionary on column id %d and rowgroup id %d. Restore the data from a backup.

SQL Server Error Msg 40534 – A valid SID is already associated with the database owner.

SQL Server Error Msg 33282 – Column ‘%.*ls.%.*ls’ is encrypted using a randomized encryption type and is therefore not valid for use as a key column in a constraint, index, or statistics.