SQL Server Errors

Can only use IF UPDATE within a CREATE TRIGGER statement.

Error Message:Msg 140, Level 15, State 1, Line 3Can only use IF UPDATE within a CREATE TRIGGER statement. Severity level:15. Description:This error message appears when you try to specify an IF UPDATE statement outside the scope of a trigger. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level […]

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

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