SQL Server Errors

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

Cascading foreign key ‘%.*ls’ cannot be created where the referencing column ‘%.*ls.%.*ls’ is an identity column.

Error Message:Msg 1788, Level 16, State 0, Line 1Cascading foreign key ‘%.*ls’ cannot be created where the referencing column ‘%.*ls.%.*ls’ is an identity column. Severity level:16. Description:This error message appears when you try to create a cascading referential integrity operation for a column for which the IDENTITY property was created. Consequences:The T-SQL statement can be […]

The correlation name ‘%.*ls’ has the same exposed name as table ‘%.*ls’.

Error Message:Msg 1012, Level 16, State 1, Line 1The correlation name ‘%.*ls’ has the same exposed name as table ‘%.*ls’. Severity level:16. Description:This error message appears when you try to use a name for a derived table that is already used by another table withing the same scope in a query. Consequences:The T-SQL statement can […]

Skipping FOREIGN KEY constraint ‘%.*ls’ definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.

Error Message:Skipping FOREIGN KEY constraint ‘%.*ls’ definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables. Severity level: Description:This informal message appears when you try to create a FOREIGN KEY constraint for a temporary table. Consequences:The T-SQL statement can be executed, but the part mentioned in the message will […]

Cannot use CHECKSUM(*) in a computed column definition.

Error Message:Msg 1789, Level 16, State 1, Line 1Cannot use CHECKSUM(*) in a computed column definition. Severity level:16. Description:This error message appears when you try to the CHECKSUM(*) function in the definition of a computed column. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are […]