SQL Server Errors

‘%.*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 […]

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 |