SQL Server Errors

Invalid usage of the option %.*ls in the %ls statement.

Error Message:Msg 153, Level 15, State 1, Line 7Invalid usage of the option %.*ls in the %ls statement. Severity level:15. Description:This error message appears when you try to use an option in an invalid context. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 are generated by […]

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

The column “%.*ls” cannot be modified because it is either a computed column or is the result of a UNION operator

Error Message:Msg 271, Level 16, State 1, Line 13The column “%.*ls” cannot be modified because it is either a computed column or is the result of a UNION operator. Severity level:16. Description:This error message appears when during an UPDATE operation either the value for a computed column in a base table should be modified or […]

‘%.*ls’ is not a constraint.

Error Message:Msg 3728, Level 16, State 1, Line 1‘%.*ls’ is not a constraint. Severity level:16. Description:This error message appears when you try to DROP a constraint that either does not exist or to which you want to refer by a name under which no constraint is known in the database. Consequences:The T-SQL statement can be […]

Cannot update a timestamp column

Error Message:Msg 272, Level 16, State 1, Line 4Cannot update a timestamp column. Severity level:16. Description:This error message appears when you try to update a table column of type TIMESTAMP. 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 user and can […]

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