SQL Server Errors

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

The correlation name ‘%.*ls’ is specified multiple times in a FROM clause.

Error Message:Msg 1011, Level 16, State 1, Line 1The correlation name ‘%.*ls’ is specified multiple times in a FROM clause. Severity level:16. Description:This error message appears when you try to use the same name for more than one derived table withing the same scope in a query. Consequences:The T-SQL statement can be parsed, but causes […]

Defaults cannot be created on columns with an IDENTITY attribute. Table ‘%.*ls’, column ‘%.*ls’.

Error Message:Msg 1754, Level 16, State 0, Line 1Defaults cannot be created on columns with an IDENTITY attribute. Table ‘%.*ls’, column ‘%.*ls’. Severity level:16. Description:This error message appears when you try to create a DEFAULT on a column with the IDENTITY property. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error […]