SQL Server Errors

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

Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index.

Error Message:Msg 1919, Level 16, State 1, Line 1Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index. Severity level:16. Description:This error message appears when you try to create an index on (a) column(s) of invalid data types for an index. Consequences:The T-SQL statement […]

The CREATE DATABASE statement failed. The primary file must be at least %d MB to accommodate a copy of the model database.

Error Message:Msg 1803, Level 16, State 1, Line 1The CREATE DATABASE statement failed. The primary file must be at least %d MB to accommodate a copy of the model database. Severity level:16. Description:This error message appears when you try to create a database, but the data file is not sufficiently sized to accomodate a copy […]

The SET SHOWPLAN statements must be the only statements in the batch.

Error Message:Msg 1067, Level 15, State 2, Line 1The SET SHOWPLAN statements must be the only statements in the batch. Severity level:15. Description:This error message appears when you try to use a SET SHOWPLAN statement together with other statement on the same batch. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

Cross-database foreign key references are not supported. Foreign key ‘%.*ls’.

Error Message:Msg 1763, Level 16, State 0, Line 1Cross-database foreign key references are not supported. Foreign key ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a FOREIGN KEY constraint that references a table in another database. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

Cannot create more than one clustered index on %S_MSG ‘%.*ls’. Drop the existing clustered index ‘%.*ls’ before creating another.

Error Message:Msg 1902, Level 16, State 3, Line 1Cannot create more than one clustered index on %S_MSG ‘%.*ls’. Drop the existing clustered index ‘%.*ls’ before creating another. Severity level:16. Description:This error message appears when you try to create a clustered index on a table, for which already a clustered index exists. Consequences:The T-SQL statement can […]

Creation of temporary functions is not allowed.

Error Message:Msg 1074, Level 15, State 1, Line 1Creation of temporary functions is not allowed. Severity level:15. Description:This error message appears when you try to create a temporary function. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level 15 are generated by the user and can be fixed […]

Foreign key ‘%.*ls’ references invalid table ‘%.*ls’.

Error Message:Msg 1767, Level 16, State 0, Line 1Foreign key ‘%.*ls’ references invalid table ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a FOREIGN KEY constraint that references an invalid table. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated […]