SQL Server Errors

Cannot define PRIMARY KEY constraint on nullable column in table ‘%1!’.

Error Message:Msg 8111, Level 16, State 1, Line 1Cannot define PRIMARY KEY constraint on nullable column in table ‘%1!’. Severity level:16. Description:This error message appears, when you try within a CREATE TABLE statement to create a PRIMARY KEY constraint on a column or a set of columns that allow NULLs. Consequences:The T-SQL statement can be […]

Ambiguous column name ‘%.*ls’.

Error Message: Msg 209, Level 16, State 1, Line 1Ambiguous column name ‘%.*ls’. Severity level: 16. Description:This error message appears when SQL Server is not able to uniquely resolve the column name in the statement. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 16 are generated by […]

Cannot update identity column ‘%1!’.

Error Message:Msg 8102, Level 16, State 1, Line 2Cannot update identity column ‘%1!’. Severity level:16. Description:This error message appears, when you try to UPDATE one or more rows of a column on which the IDENTITY property has been defined Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

A domain error occurred.

Error Message:Msg 3623, Level 16, State 1, Line 1A domain error occurred. Severity level:16. Description:This error message appears, when you to perform an, at least for SQL Server, mathematical illegal operation. 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 […]

There is already an object named ‘%1!’ in the database.

Error Message:Msg 2714, Level 16, State 6, Line 2There is already an object named ‘%1!’ in the database. Severity level:16. Description:This error message appears when you try to create an object wit a name that already exists in the database. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

A TOP N value may not be negative.

Error Message:Msg 127, Level 15, State 1, Line 1A TOP N value may not be negative. Severity level:15. Description:This error message appears when you try to use a negative value in the TOP clause. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level 15 are generated by […]

Conversion failed when converting datetime from character string.

Error Message:Msg 241, Level 16, State 1, Line 3Conversion failed when converting datetime from character string. Severity level:16. Description:This error message appears, when SQL Server cannot convert a string to a valid DATETIME value. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level 16 are generated by […]

Invalid object name ‘%1!’.

Error Message:Msg 208, Level 16, State 1, Line 1Invalid object name ‘%1!’. Severity level:16. Description:This error message appears when you try to reference an object that does not exist in the current database. 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 […]

Arithmetic overflow error for data type %1!, value = %2!.

Error Message:Msg 220, Level 16, State 2, Line 2Arithmetic overflow error for data type %1!, value = %2!. Severity level:16. Description:This error message appears, when the assigment of a value to a variable fails, because the value is larger than the maximum allowed value for the datatype of the variable. Consequences:The T-SQL statement can be […]

The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.

Error Message: Server: Msg 120, Level 15, State 1, Line 6The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns. Severity level: 15. Description:This error message appears when you try to INSERT a row into a table and there […]
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 |