Tag: SQL Server Errors

SQL Server Error Msg 33179 – Searching for ‘%.*ls’ only searches “‘%.*ls’” for SQL Server authentication logins.

SQL Server Error Msg 15160 – Cannot issue impersonation token from non-primary impersonation context or for non-Windows user.

SQL Server Error Msg 22110 – The number of columns specified in the CHANGETABLE(VERSION …) function does not match the number of primary key columns for table ‘%.*ls’.

SQL Server Error Msg 14307 – Access to Integration Services package ‘%s’ is denied.

SQL Server Error Msg 14522 – ‘”%s” is not a valid role of an msdb database, Windows NT user, or Windows NT group.

SQL Server Error Msg 45214 – @days_of_week must be specified if @full_backup_freq_type is set to ‘Weekly’

SQL Server Error Msg 21584 – Cannot insert the row for article ‘%s’. The row does not belong to the Subscriber’s partition, and the article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property. Nonoverlapping partitions do not allow out-of-partition inserts.

SQL Server Error Msg 20714 – Failed to prepare article ‘%s’ in publication ‘%s’ for merge replication.

SQL Server Error Msg 5504 – ‘PRIMARY’ can only be specified for FILESTREAM log filegroup in a ‘CONTAINS’ clause.

SQL Server Error Msg 39129 – Cannot drop external language ‘%.*ls’ because it is being referenced by external library ‘%.*ls’.

SQL Server Error Msg 40976 – Instance Failover Group cannot be created because partner managed server “%.*ls” is not empty or does not have secondaries for all databases in the primary instance  “%.*ls” .

SQL Server Error Msg 19221 – The connection was closed while attempting to process a read buffer during a cryptographic handshake.

SQL Server Error Msg 19503 – Cannot create a distributed availability replica for availability group ‘%.*ls’.  Local availability group is participating in a distributed availability group as secondary.

SQL Server Error Msg 40201 – Destination server name is too long.

SQL Server Error Msg 41385 – A memory-optimized table cannot be enabled for Change Data Capture (CDC).

SQL Server Error Msg 18810 – Cannot restart the scan on table ‘%s’. HRESULT = ‘0x%x’. Stop and restart the Log Reader Agent. If the problem persists, contact Customer Support Services.

SQL Server Error Msg 43011 – ‘%.*ls’ is not a valid version.

SQL Server Error Msg 30078 – The fulltext query did not use the value specified for the OPTIMIZE FOR hint because the query contained more than one type of full-text logical operator.

SQL Server Error Msg 18227 – Unnamed tape (family ID %d, sequence %d, media_set_guid %s) is mounted on tape drive ‘%s’. This is an informational message only. No user action required.

SQL Server Error Msg Switching out partition failed on table ‘%.*ls’ because it is not a supported operation on system-versioned tables. Consider setting SYSTEM_VERSIONING to OFF and trying again. – 16