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

The %S_MSG ‘%.*ls’ on table ‘%.*ls’ has %d column names in %S_MSG key list. The maximum limit for index or statistics key column list is %d.

Error Message:Msg 1904, Level 16, State 1, Line 1The %S_MSG ‘%.*ls’ on table ‘%.*ls’ has %d column names in %S_MSG key list. The maximum limit for index or statistics key column list is %d. Severity level:16. Description:This error message appears when you try to create an index or a constraint with more than 16 columns. […]

Cannot use duplicate column names in %S_MSG. Column name ‘%.*ls’ listed more than once.

Error Message:Msg 1909, Level 16, State 1, Line 1Cannot use duplicate column names in %S_MSG. Column name ‘%.*ls’ listed more than once. Severity level:16. Description:This error message appears when you try to use a column name more than once for an operation. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error […]

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