SQL Server Errors

There are already statistics on table ‘%.*ls’ named ‘%.*ls’.

Error Message:Msg 1927, Level 16, State 2, Line 1There are already statistics on table ‘%.*ls’ named ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a statistic for a table or view, but another statistic with the same name already exists in the database. Consequences:The T-SQL statement can be parsed, but causes […]

Cannot create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option while table has an XML Index.

Error Message:Msg 1996, Level 16, State 1, Line 1Cannot create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option while table has an XML Index. Severity level:16. Description:This error message appears when you try to rebuild an index that is used to enforce a PRIMARY KEY constraint while there is a XML index on this […]

Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view.

Error Message:Msg 1929, Level 16, State 1, Line 1Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view. Severity level:16. Description:This error message appears when you try to create a statistic for an object that is not a table or a view. Consequences:The T-SQL statement can be parsed, […]

Procedures with a group number cannot have parameters of xml or sqlclr user defined types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’.

Error Message:Msg 2003, Level 16, State 1, Procedure ShowMe, Line 5Procedures with a group number cannot have parameters of xml or sqlclr user defined types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’. Severity level:16. Description:This error message appears when you try to use a parameter of the XML type or a SQLCLR-defined type in […]

Column name ‘%.*ls’ does not exist in the target table or view.

Error Message:Msg 1911, Level 16, State 1, Line 2Column name ‘%.*ls’ does not exist in the target table or view. Severity level:16. Description:This error message appears when you try to create an index on a table or view, but the specified column name does not exist in these objects. Consequences:The T-SQL statement can be parsed, […]

The operation failed because an index or statistics with name ‘%.*ls’ already exists on %S_MSG ‘%.*ls’.

Error Message:Msg 1913, Level 16, State 1, Line 1The operation failed because an index or statistics with name ‘%.*ls’ already exists on %S_MSG ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create an index while another index with the same name already exists. Consequences:The T-SQL statement can be parsed, but causes the […]

Index cannot be created on object ‘%.*ls’ because the object is not a user table or view.

Error Message:Msg 1914, Level 16, State 1, Line 1Index cannot be created on object ‘%.*ls’ because the object is not a user table or view. Severity level:16. Description:This error message appears when you try to create an index on the object that is not a table or a view. Consequences:The T-SQL statement can be parsed, […]

Cannot alter a non-unique index with ignore_dup_key index option. Index ‘%.*ls’ is non-unique.

Error Message:Msg 1915, Level 16, State 1, Line 1Cannot alter a non-unique index with ignore_dup_key index option. Index ‘%.*ls’ is non-unique. Severity level:16. Description:This error message appears when you try to use the IGNORE_DUP_KEY option for a non-unique index. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

CREATE INDEX options %ls and %ls are mutually exclusive.

Error Message:Msg 1916, Level 16, State 4, Line 1CREATE INDEX options %ls and %ls are mutually exclusive. Severity level:16. Description:This error message appears when you try to use two options in a CREATE INDEX statement that are mutually exclusive. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

Cannot create, rebuild or drop an index on a local temporary table online. Perform the index operation offline.

Error Message:Msg 1917, Level 16, State 1, Line 1Cannot create, rebuild or drop an index on a local temporary table online. Perform the index operation offline. Severity level:16. Description:This error message appears when you try to create an index online for a local temporary table. Consequences:The T-SQL statement can be parsed, but causes the error […]