SQL Server Errors

Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’. Only XML Index can be created on XML column ‘%.*ls’.

Error Message:Msg 1977, Level 16, State 1, Line 1Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’. Only XML Index can be created on XML column ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a relational index for a column of the XML data type. Consequences:The T-SQL statement can be parsed, but […]

Violation of %ls constraint ‘%.*ls’. Cannot insert duplicate key in object ‘%.*ls’.

Error Message:Msg 2627, Level 14, State 1, Line 10Violation of %ls constraint ‘%.*ls’. Cannot insert duplicate key in object ‘%.*ls’. Severity level:14. Description:This error message appears when you try to insert an already existing value into a column for which a PRIMARY KEY or UNIQUE constraint was declared. Consequences:The T-SQL statement can be parsed, but […]

Cannot convert a clustered index to a nonclustered index by using the DROP_EXISTING option. To change the index type from clustered to nonclustered, delete the clustered index, and then create a nonclustered index by using two separate statements.

Error Message:Msg 1925, Level 16, State 2, Line 1Cannot convert a clustered index to a nonclustered index by using the DROP_EXISTING option. To change the index type from clustered to nonclustered, delete the clustered index, and then create a nonclustered index by using two separate statements. Severity level:16. Description:This error message appears when you try […]

Cannot rebuild clustered index ‘%.*ls’ online because it is disabled.

Error Message:Msg 1988, Level 16, State 1, Line 1Cannot rebuild clustered index ‘%.*ls’ online because it is disabled. Severity level:16. Description:This error message appears when you try to rebuild a disabled clustered index online. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated by […]

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 […]

Cannot create %S_MSG on view ‘%.*ls’ because the view is not schema bound.

Error Message:Msg 1939, Level 16, State 1, Line 2Cannot create %S_MSG on view ‘%.*ls’ because the view is not schema bound. Severity level:16. Description:This error message appears when you try to create an indexed view that is not schema-bound. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number.

Error Message:Msg 2004, Level 16, State 1, Procedure ShowMe, Line 5Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number. Severity level:16. Description:This error message appears when you try to create a procedure with a group number, but this group number already exists for this procedure. Consequences:The T-SQL […]