SQL Server Errors

Invalid %S_MSG ‘%.*ls’ specified.

Error Message:Msg 1921, Level 16, State 1, Line 1Invalid %S_MSG ‘%.*ls’ specified. Severity level:16. Description:This error message appears when you try, for example, to move an index via DROP INDEX to a non-existant filegroup. 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, […]

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