Tag: SQL Server Errors

SQL Server Error Msg 8952 – Table error: table ‘%ls’ (ID %d). Index row in index ‘%ls’ (ID %d) does not match any data row. Possible extra or invalid keys for:

SQL Server Error Msg 21762 – The distribution database ‘%s’ has a compatibility level of %d, which is different from that of the master database. The two compatibility levels must be the same, so the distribution database level is being changed to %d. This is an informational message only. No user action is required.

SQL Server Error Msg 6207 – Error converting %.*ls to fixed length binary type. The result would be padded and cannot be converted back.

SQL Server Error Msg 35266 – Always On Availability Groups connection with %S_MSG database established for %S_MSG database ‘%.*ls’ on the availability replica ‘%.*ls’ with Replica ID: {%.8x-%.4x-%.4x-%.2x%.2x-%.2x%.2x%.2x%.2x%.2x%.2x}. This is an informational message only. No user action is required.

SQL Server Error Msg 3010 – Invalid backup mirror specification. All mirrors must have the same number of members.

SQL Server Error Msg 40894 – The database copy link from ‘%s.%s’ to ‘%s.%s’ is not in the catchup state after the data copy link operation completed.

SQL Server Error Msg 35283 – Availability replica ‘%.*ls’ cannot be removed from availability group ‘%.*ls’.  The availability group does not contain an availability replica with the specified name.  Verify that the availability replica name is correct, then retry the operation.

SQL Server Error Msg 41871 – Failed to recreate XTP non-durable tables during recovery of the database ‘%.*ls’.

SQL Server Error Msg 21824 – Can not add constraints to multiple columns because table %s is published but column %s is not in all active partitions, please use separate DDL statement.

SQL Server Error Msg 13173 – master key

SQL Server Error Msg 25029 – Replication distribution database ‘%s’ is not in the primary replica of its availability group.

SQL Server Error Msg 7941 – Table error: object ID %d, index ID %d, partition ID %I64d processing encountered file name “%.*ls” twice in the column ID %d (for column directory %d container ID %d).

SQL Server Error Msg 14097 – The ‘status’ value must be ‘no column names’, ‘include column names’, ‘string literals’, ‘parameters’, ‘DTS horizontal partitions’ or ‘no DTS horizontal partitions’.

SQL Server Error Msg 3730 – Cannot drop the default constraint ‘%.*ls’ while it is being used by a foreign key as SET DEFAULT referential action.

SQL Server Error Msg 35267 – Always On Availability Groups connection with %S_MSG database terminated for %S_MSG database ‘%.*ls’ on the availability replica ‘%.*ls’ with Replica ID: {%.8x-%.4x-%.4x-%.2x%.2x-%.2x%.2x%.2x%.2x%.2x%.2x}. This is an informational message only. No user action is required.

SQL Server Error Msg 9810 – The datepart %.*ls is not supported by date function %.*ls for data type %s.

SQL Server Error Msg 22842 – ALTER TABLE SWITCH statement failed because the partitioned destination table is enabled for Change Data Capture and does not have @allow_partition_switch set to 1.

SQL Server Error Msg 8305 – The TEXT IN ROW feature will be removed in a future version of SQL Server. Avoid using sp_tableoption for TEXT IN ROW option in new development work, and plan to modify applications that currently use the text in row option. The preferred method of storing large data is through use of the varchar(max), nvarchar(max) and varbinary(max) data types.

SQL Server Error Msg 22938 – Role name ‘%s’ is invalid. Specify a valid name. See the topic ‘Identifiers’ in SQL Server Books Online for object name rules.

SQL Server Error Msg 1806 – CREATE DATABASE failed. The default collation of database ‘%.*ls’ cannot be set to ‘%.*ls’.