SQL Server Errors

Foreign key references to temporary tables are not supported. Foreign key ‘%.*ls’.

Error Message: Msg 1766, Level 16, State 0, Line 3 Foreign key references to temporary tables are not supported. Foreign key ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to create a foreign key constraint referencing a temporary table. Consequences: The T-SQL statement can be parsed, but causes the error at […]

The %S_MSG ‘%.*ls’ is out of the range for numeric representation (maximum precision 38).

Error Message: Msg 1007, Level 15, State 1, Line 3 The %S_MSG ‘%.*ls’ is out of the range for numeric representation (maximum precision 38). Severity level: 15. Description: This error message appears when a numerischer Wert ausserhalb des Bereiches für die Darstellung numerischer Werte liegt. Consequences: The SQL statement cannot be parsed and further execution […]

Cannot create foreign key ‘%.*ls’ because it references object ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled.

Error Message: Msg 1771, Level 16, State 1, Line 12 Cannot create foreign key ‘%.*ls’ because it references object ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled. Severity level: 16. Description: This error message appears when you try to create a foreign key constraint referencing a table whose clustered index is disabled. Consequences: The T-SQL statement […]

Syntax error: Duplicate specification of the action “%.*s” in the trigger declaration.

Error Message: Msg 1034, Level 15, State 1, Procedure, Line 2 Syntax error: Duplicate specification of the action “%.*s” in the trigger declaration. Severity level: 15. Description: This error message appears when in a trigger definition the event for which the trigger should fire is specified more than once. Consequences: The SQL statement cannot be […]

Cannot create the foreign key ‘%.*ls’ because the referenced column ‘%.*ls.%.*ls’ is a non-persisted computed column.

Error Message: Msg 1784, Level 16, State 1, Line 9 Cannot create the foreign key ‘%.*ls’ because the referenced column ‘%.*ls.%.*ls’ is a non-persisted computed column. Severity level: 16. Description: This error message appears when you try to create a foreign key constraint referencing a non-persisted computed column. Consequences: The T-SQL statement can be parsed, […]

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

Error Message: Msg 205, Level 16, State 1, Line 1 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. Severity level: 16. Description: This error message appears when you try to run a UNION, INTERSECT or EXCEPT query that has not an equal […]

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [] are not allowed. Add a name or single space as the alias name.

Error Message: Msg 1038, Level 15, State 5, Line 1 An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [] are not allowed. Add a name or single space as the alias […]

Operation failed. The index entry of length %d bytes for the index ‘%.*ls’ exceeds the maximum length of %d bytes.

Error Message: Msg 1946, Level 16, State 3, Line 10 Operation failed. The index entry of length %d bytes for the index ‘%.*ls’ exceeds the maximum length of %d bytes. Severity level: 16. Description: This error message appears when you try to insert or update a row and an index entry exceeds the maximum allowed […]

The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.

Error Message: Msg 298, Level 16, State 1, Line 4 The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error. Severity level: 16. Description: This error message appears when you try to convert a datetime value into a smalldatetime value, but this value is outside the range of valid […]

The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION, INTERSECT or EXCEPT operator.

Error Message: Msg 1057, Level 15, State 5, Line 11 The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION, INTERSECT or EXCEPT operator. Severity level: 15. Description: This error message appears when in a SELECT INTO statement that involves a UNION, INTERSECT, or EXCEPT operator, the IDENTITY function shall be […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |