SQL Server Errors

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

Cannot find the object “%.*ls” because it does not exist or you do not have permissions.

Error Message:Msg 1088, Level 16, State 12, Line 2Cannot find the object “%.*ls” because it does not exist or you do not have permissions. Severity level:16. Description:This error message appears when you try to reference a database object that either does not exist, or to which you don’t have access permission. Consequences:The T-SQL statement can […]

Foreign key ‘%.*ls’ references object ‘%.*ls’ which is not a user table.

Error Message:Msg 1768, Level 16, State 0, Line 1Foreign key ‘%.*ls’ references object ‘%.*ls’ which is not a user table. Severity level:16. Description:This error message appears when you try to create a FOREIGN KEY constraint for a table and the FOREIGN KEY references a database object that is not a table. Consequences:The T-SQL statement can […]

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