SQL Server Errors

Constraint name ‘%.*ls’ not permitted. Constraint names cannot begin with a number sign (#).

Error Message: Msg 8166, Level 16, State 0, Line 2 Constraint name ‘%.*ls’ not permitted. Constraint names cannot begin with a number sign (#). Severity level: 16. Description: This error message appears when you try to create a constraint beginning with the # number sign. Consequences: The T-SQL statement can be parsed, but causes the […]

Column names in each view or function must be unique. Column name ‘%.*ls’ in view or function ‘%.*ls’ is specified more than once.

Error Message: Msg 4506, Level 16, State 1, Procedure v, Line 4 Column names in each view or function must be unique. Column name ‘%.*ls’ in view or function ‘%.*ls’ is specified more than once. Severity level: 16. Description: This error message appears when you try to create a view or function that has non-unique […]

The ‘COMPUTE’ clause is not allowed in a statement containing an INTERSECT or EXCEPT operator.

Error Message: Msg 323, Level 16, State 1, Line 1 The ‘COMPUTE’ clause is not allowed in a statement containing an INTERSECT or EXCEPT operator. Severity level: 16. Description: This error message appears when you try to use the COMPUTE clause in a statement containing an INTERSECT or EXCEPT operator. Consequences: The T-SQL statement can […]

Warning! The maximum key length is %d bytes. The index ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.

Error Message: Warning! The maximum key length is %d bytes. The index ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length is %d bytes. The index ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update […]

Incorrect syntax near the keyword ‘with’. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

Error Message: Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword ‘with’. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Severity level: 15. Description: This error message appears when you try to use a common table expression or […]

GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error Message: Msg 467, Level 16, State 1, Line 2 GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression ‘%.*ls’. Severity level: 16. Description: This error message appears when you try to use a GROUP BY or HAVING clause or a subquery in the recursive […]

Only functions and extended stored procedures can be executed from within a function.

Error Message: Msg 557, Level 16, State 2, Line 2 Only functions and extended stored procedures can be executed from within a function. Severity level: 16. Description: This error message appears when you try to execute a normal stored procedure within a function. Consequences: The T-SQL statement can be parsed, but causes the error at […]

INSERT EXEC failed because the stored procedure altered the schema of the target table.

Error Message: Msg 556, Level 16, State 3, Line 2 INSERT EXEC failed because the stored procedure altered the schema of the target table. Severity level: 16. Description: This error message appears when you try to execute an INSERT…EXEC statement in which the procedure in the EXEC part alters the table definition of the table […]

Cannot issue SAVE TRANSACTION when there is no active transaction.

Error Message: Msg 628, Level 16, State 0, Line 1 Cannot issue SAVE TRANSACTION when there is no active transaction. Severity level: 16. Description: This error message appears when you try to run a SAVE TRANSACTION statement when there is no active transaction. Consequences: The T-SQL statement can be parsed, but causes the error at […]

Hint ‘%ls’ on object ‘%.*ls’ is invalid.

Error Message: Msg 8171, Level 16, State 1, Line 7 Hint ‘%ls’ on object ‘%.*ls’ is invalid. Severity level: 16. Description: This error message appears when you try to use a hints that is invalid on the given object. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Error of […]
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 |