Tag: SQL Server Errors

SQL Server Error Msg 39122 – CREATE statement failed. External language ‘%.*ls’ already exists.

SQL Server Error Msg 9806 – The datepart %.*ls is not supported by date function %.*ls.

SQL Server Error Msg 14822 – ‘%s’ is not a valid option for the @mode parameter. Enter  ‘ALL’, ‘LOCAL_ONLY’ or ‘REMOTE_ONLY’.

SQL Server Error Msg 10603 – Cannot rebuild clustered index ‘%.*ls’ on view ‘%.*ls’ because the view is dependent on base table ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled.

SQL Server Error Msg 260 – Disallowed implicit conversion from data type %ls to data type %ls, table ‘%.*ls’, column ‘%.*ls’. Use the CONVERT function to run this query.

SQL Server Error Msg 9621 – An error occurred while processing a message in the Service Broker and Database Mirroring transport: error %i, state %i.

SQL Server Error Msg 21616 – Cannot find column [%s] in the article. Verify that the column exists in the underlying table, and that it is included in the article.

SQL Server Error Msg 8302 – CREATE RULE and DROP RULE will be removed in a future version of SQL Server. Avoid using CREATE RULE and DROP RULE in new development work, and plan to modify applications that currently use them. Use check constraints instead, which are created using the CHECK keyword of CREATE TABLE or ALTER TABLE.

SQL Server Error Msg 20047 – You are not authorized to perform this operation.

SQL Server Error Msg 33148 – The user name for a windows login has to be identical to the login name.

SQL Server Error Msg 13029 – table

SQL Server Error Msg 4145 – An expression of non-boolean type specified in a context where a condition is expected, near ‘%.*ls’.

SQL Server Error Msg 16 – 596

SQL Server Error Msg 20007 – The system tables for merge replication could not be dropped successfully.

SQL Server Error Msg 47039 – Reason: Login failed because the client is attempting to use certificate authentication without correct permissions.

SQL Server Error Msg 21296 – Parameter @resync_type must be either 0, 1, 2.

SQL Server Error Msg 8671 – The attempt to maintain the indexed view “%.*ls” failed because of the ignore_dup_key option on index “%.*ls”. Drop the index or re-create it without the ignore_dup_key index option.

SQL Server Error Msg 28604 – Transaction Coordination Manager is starting up. This is an informational message only. No user action is required.

SQL Server Error Msg 21856 – For a .NET Assembly Business Logic Handler, the .NET Assembly name should be the name of a valid assembly in ‘%s’ that contains the class that implements the Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule interface. Check the registration of the business logic handler to make sure the .NET Assembly name was specified correctly.

SQL Server Error Msg 6252 – ALTER ASSEMBLY failed because a file name was not specified for the inline assembly file parameter %d.