Tag: SQL Server Errors

SQL Server Error Msg 22586 – Column ‘%s’ cannot be added or modified in article ‘%s’ of publication ‘%s’. The DDL operatoin on hierarchyid and FILESTREAM columns is not supported for publications that have a ‘sync_mode’ of 1 (character mode) or with a lower than 90RTM backward compatibility level.

SQL Server Error Msg 14576 – @freq_interval must be between 1 and 10 (1 = Sunday .. 7 = Saturday, 8 = Day, 9 = Weekday, 10 = Weekend-day) for a monthly-relative job.

SQL Server Error Msg 17657 – Attempting to change default collation to %s.

SQL Server Error Msg 33079 – Cannot bind a default or rule to the CLR type ‘%s’ because an existing sparse column uses this data type. Modify the data type of the sparse column or remove the sparse designation of the column.

SQL Server Error Msg 5540 – The FILESTREAM column cannot be used with method %ls because the associated ROWGUIDCOL of the base table is nullable or does not have a unique constraint.

SQL Server Error Msg 495 – The return table column “%.*ls” is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.

SQL Server Error Msg 8973 – CHECKTABLE object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) processing encountered page %S_PGID, slot %d twice.

SQL Server Error Msg 10515 – Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission.

SQL Server Error Msg 27243 – Cannot find the cluster worker agent ‘%ls’ because it does not exist or you do not have sufficient permissions.

SQL Server Error Msg 4815 – Received an invalid column length from the bcp client for colid %d.

SQL Server Error Msg 997 – Failed to get the update lock on database ‘%.*ls’.

SQL Server Error Msg 16 – 12435

SQL Server Error Msg 21633 – The publication ‘%s’ could not be added because non-SQL Server Publishers only support the @sync_method parameter values “character” or “concurrent_c”.

SQL Server Error Msg 20587 – Invalid ‘%s’ value for stored procedure ‘%s’.

SQL Server Error Msg 1417 – Database mirroring has been disabled by the administrator for database “%.*ls”.

SQL Server Error Msg 18380 – Reason: The certificate is invalid or expired.

SQL Server Error Msg 8568 – Microsoft Distributed Transaction Coordinator (MS DTC) failed to reenlist citing that the database RMID does not match the RMID [%ls] associated with the transaction.  Please manually resolve the transaction.

SQL Server Error Msg 15147 – No decryption password should be provided because the private key of this %S_MSG is encrypted by a master key.

SQL Server Error Msg 3454 – Recovery is writing a checkpoint in database ‘%.*ls’ (%d). This is an informational message only. No user action is required.

SQL Server Error Msg 5121 – The path specified by “%.*ls” is not in a valid directory.