SQL Server Errors

The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.

Error Message:Msg 132, Level 15, State 1, Line 11The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure. Severity level:15. Description:This error message appears when you try to specify a label more than once. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error […]

An aggregate may not appear in a computed column expression or check constraint

Error Message:Msg 175, Level 15, State 1, Line 1An aggregate may not appear in a computed column expression or check constraint. Severity level:15. Description:This error message appears when an aggregate appear in a computed column expression or in a CHECK constraint. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

The scale (%d) for column ‘%.*ls’ must be within the range %d to %d.

Error Message:Msg 183, Level 15, State 1, Line 3The scale (%d) for column ‘%.*ls’ must be within the range %d to %d. Severity level:15. Description:This error message appears when you try to create a column of type DECIMAL (synonym NUMERIC) in which the number of decimal places is greater than the number of digits that […]

The scale must be less than or equal to the precision

Error Message:Msg 192, Level 15, State 1, Line 1The scale must be less than or equal to the precision. Severity level:15. Description:This error message appears when you try to declare a variable of type DECIMAL (synonym NUMERIC) in which the number of decimal places is greater than the number of digits that the variable can […]

Procedure or function ‘%.*ls’ expects parameter ‘%.*ls’, which was not supplied.

Error Message:Msg 201, Level 16, State 4, Procedure BogusOrder, Line 0Procedure or function ‘%.*ls’ expects parameter ‘%.*ls’, which was not supplied. Severity level:16. Description:This error message appears when you don’t supply a value for a parameter expected by a stored procedure. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

Conversion failed when converting datetime from binary/varbinary string

Error Message:Msg 210, Level 16, State 1, Line 3Conversion failed when converting datetime from binary/varbinary string. Severity level:16. Description:This error message appears when you try to convert an invalid BINARY(VARBINARY) string to a value of type DATETIME. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 […]

Insert Error: Column name or number of supplied values does not match table definition

Error Message:Msg 213, Level 16, State 1, Line 8Insert Error: Column name or number of supplied values does not match table definition. Severity level:16. Description:This error message appears when during an INSERT operation either the number of supplied column names or the number of supplied values does not match the table definition. Consequences:The T-SQL statement […]

Cannot back up the log of the master database. Use BACKUP DATABASE instead

Error Message:Msg 4212, Level 16, State 1, Line 2Cannot back up the log of the master database. Use BACKUP DATABASE instead. Severity level:16. Description:This error message appears when you try to backup the log of the master database. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level […]

Parameters were not supplied for the function ‘%.*ls’.

Error Message:Msg 216, Level 16, State 1, Line 1Parameters were not supplied for the function ‘%.*ls’. Severity level:16. Description:This error message appears when you don’t supply a value expected by a user-defined function. 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 […]

The query uses non-ANSI outer join operators.

Error Message:Msg 4147, Level 15, State 1, Line 3The query uses non-ANSI outer join operators (“*=” or “=*”). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER […]
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 |