SQL Server Errors

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

Cannot alter column ‘%.*ls’ to be data type %.*ls

Error Message:Msg 4927, Level 16, State 1, Line 1Cannot alter column ‘%.*ls’ to be data type %.*ls. Severity level:16. Description:This error message appears when you try to change the data type of a column from one type to another, but that conversion is not allowed. Consequences:The T-SQL statement can be parsed, but causes the error […]

Process ID %d is not a valid process ID. Choose a number between 1 and %d

Error Message:Msg 6101, Level 16, State 1, Line 1Process ID %d is not a valid process ID. Choose a number between 1 and %d. Severity level:16. Description:This error message appears when you try to terminate an invalid process-ID via KILL. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

Cannot use KILL to kill your own process

Error Message:Msg 6104, Level 16, State 1, Line 1Cannot use KILL to kill your own process. Severity level:16. Description:This error message appears when you try to terminate your own process via KILL. 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 […]

Process ID %d is not an active process ID

Error Message:Msg 6106, Level 16, State 1, Line 1Process ID %d is not an active process ID. Severity level:16. Description:This error message appears when you try to terminate a inactive process via the KILL command. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated […]

Only user processes can be killed

Error Message:Msg 6107, Level 14, State 1, Line 1Only user processes can be killed. Severity level:14. Description:This error message appears when you try to terminate a system process via the KILL command. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 14 are generated by the user […]
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 |