Tag: SQL Server Errors

SQL Server Error Msg 457 – Implicit conversion of %ls value to %ls cannot be performed because the collation of the value is unresolved due to a collation conflict between “%ls” and “%ls” in %ls operator.

SQL Server Error Msg 6613 – Specified value ‘%ls’ already exists.

SQL Server Error Msg 41186 – Availability group ‘%.*ls’ cannot process an ALTER AVAILABILITY GROUP command at this time.  The availability group is still being created.  Verify that the specified availability group name is correct.  Wait for CREATE AVAILABILITY GROUP command to finish, and then retry the operation.

SQL Server Error Msg 10795 – The variable ‘%.*ls’ was declared as not null, and must be declared with an initial value.

SQL Server Error Msg 14109 – The @security_mode parameter value must be 0 (SQL Server Authentication) or 1 (Integrated Authentication).

SQL Server Error Msg 22812 – The roundtrip ‘%s’ finished with timeout:  %d seconds.

SQL Server Error Msg 21133 – Publication ‘%s’ is not enabled to use an independent agent.

SQL Server Error Msg 15299 – The signature of the public key is invalid.

SQL Server Error Msg 9789 – Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb.

SQL Server Error Msg 16604 – Hub database ‘%ls’ is invalid.

SQL Server Error Msg 21074 – The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

SQL Server Error Msg 1787 – Cannot define foreign key constraint ‘%.*ls’ with cascaded DELETE or UPDATE on table ‘%.*ls’ because the table has an INSTEAD OF DELETE or UPDATE TRIGGER defined on it.

SQL Server Error Msg 7613 – Cannot drop index ‘%.*ls’ because it enforces the full-text key for table or indexed view ‘%.*ls’.

SQL Server Error Msg 19096 – Fail to delete an old trace file ‘%ls’. Error = ‘%ls’.

SQL Server Error Msg 21045 – Cannot uninstall the Distributor because there are databases enabled for publishing or merge publishing.

SQL Server Error Msg 20026 – The publication ‘%s’ does not exist.

SQL Server Error Msg 9120 – The statistics name ‘%.*ls’ is corrupt and must be dropped. If it is an index stats, the index must be rebuilt.

SQL Server Error Msg Must specify the table name and index name for the DROP INDEX statement. – 15

SQL Server Error Msg 4198 – Collation ‘%.*ls’ is supported on Unicode data types only. Unicode-only collations cannot be used to specify partition function parameters.

SQL Server Error Msg %ld is not a valid value for system versioning history retention period. – 16