SQL Server Errors

An aggregate may not appear in the OUTPUT clause.

Error Message:Msg 158, Level 15, State 1, Line 2An aggregate may not appear in the OUTPUT clause. Severity level:15. Description:This error message appears when you try to use an aggregate function in the OUTPUT clause of an UPDATE statement. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

Could not drop constraint. See previous errors.

Error Message:Msg 3727, Level 16, State 0, Line 1Could not drop constraint. See previous errors. Severity level:16. Description:This error message appears when you try to DROP a constraint, but this however was, due to an error, not successfully completed. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

A column has been specified more than once in the order by list. Columns in the order by list must be unique

Error Message:Msg 169, Level 15, State 1, Line 1A column has been specified more than once in the order by list. Columns in the order by list must be unique. Severity level:15. Description:This error message appears when a column name in the ORDER BY clause appears more than once. Consequences:The T-SQL statement can be parsed, […]

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