SQL Server Errors

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘%.*ls’ and the index name ‘%.*ls’. The duplicate key value is %ls.

Error Message:Msg 1505, Level 16, State 1, Line 11The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘%.*ls’ and the index name ‘%.*ls’. The duplicate key value is %ls. Severity level:16. Description:This error message appears when you try to create a unique index on column(s), for which duplicate […]

Foreign key ‘%.*ls’ references invalid column ‘%.*ls’ in referenced table ‘%.*ls’.

Error Message:Msg 1770, Level 16, State 0, Line 1Foreign key ‘%.*ls’ references invalid column ‘%.*ls’ in referenced table ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a FOREIGN KEY constraint on a column that does not exist in the referenced table. Consequences:The T-SQL statement can be parsed, but causes the error […]

Creating or altering table ‘%.*ls’ failed because the minimum row size would be %d, including %d bytes of internal overhead. This exceeds the maximum allowable table row size of %d bytes.

Error Message:Msg 1701, Level 16, State 1, Line 4Creating or altering table ‘%.*ls’ failed because the minimum row size would be %d, including %d bytes of internal overhead. This exceeds the maximum allowable table row size of %d bytes. Severity level:16. Description:This error message appears when you try to create a table for which the […]

There are no primary or candidate keys in the referenced table ‘%.*ls’ that match the referencing column list in the foreign key ‘%.*ls’.

Error Message:Msg 1776, Level 16, State 0, Line 1There are no primary or candidate keys in the referenced table ‘%.*ls’ that match the referencing column list in the foreign key ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a FOREIGN KEY constraint for a table that references another table for which […]

Could not locate entry in sysdatabases for database ‘%.*ls’. No entry found with that name. Make sure that the name is entered correctly.

Error Message:Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database ‘%.*ls’. No entry found with that name. Make sure that the name is entered correctly. Severity level:16. Description:This error message appears when you try to access a database, that is not known on this SQL Server instance. Consequences:The SQL […]

Could not create constraint. See previous errors.

Error Message:Msg 1750, Level 16, State 0, Line 1Could not create constraint. See previous errors. Severity level:16. Description:This error message appears when as a result of a previous error a constraint cannot be created. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated by […]

Column ‘%.*ls.%.*ls’ is not the same data type as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’.

Error Message:Msg 1778, Level 16, State 0, Line 1Column ‘%.*ls.%.*ls’ is not the same data type as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a FOREIGN KEY constraint between columns of different data types. Consequences:The T-SQL statement can be parsed, but causes the error […]

Line %d: Length or precision specification %d is invalid.

Error Message:Msg 1001, Level 15, State 1, Line 4Line %d: Length or precision specification %d is invalid. Severity level:15. Description:This error message appears when SQL Server determines an invalid length specification in a value of a DECIMAL data type. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level […]

Column ‘%.*ls.%.*ls’ is not the same length as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’. Columns participating in a foreign key relationship must be defined with the same length.

Error Message:Msg 1753, Level 16, State 0, Line 1Column ‘%.*ls.%.*ls’ is not the same length as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’. Columns participating in a foreign key relationship must be defined with the same length. Severity level:16. Description:This error message appears when you try to create a referential integrity relation between two column […]

Either column ‘%.*ls.%.*ls’ or referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’ is a timestamp column. This data type cannot be used with cascading referential integrity constraints.

Error Message:Msg 1786, Level 16, State 0, Line 1Either column ‘%.*ls.%.*ls’ or referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’ is a timestamp column. This data type cannot be used with cascading referential integrity constraints. Severity level:16. Description:This error message appears when you try to create a cascading referential integrity operation for a column of the […]