SQL Server Errors

The conversion of the %1! value %2!’ overflowed an %3! column.

Error Message:Msg 244, Level 16, State 1, Line 1The conversion of the %1! value %2!’ overflowed an %3! column. Severity level:16. Description:This error message appears when you try to convert one INTEGER datatype into another INTEGER datatype, but the value is beyond the allowed range for that second datatype. Consequences:The T-SQL statement can be parsed, […]

Table ‘%1!’ does not have the identity property. Cannot perform SET operation.

Error Message:Msg 8106, Level 16, State 1, Line 1Table ‘%1!’ does not have the identity property. Cannot perform SET operation. Severity level:16. Description:This error message appears when you try to use the SET IDENTITY_INSERT setting for a table that does not contain a column, for which the IDENTITY property was declared. Consequences:The T-SQL statement can […]

Type %1! is not a defined system type.

Error Message:Msg 243, Level 16, State 1, Line 1Type %1! is not a defined system type. Severity level:16. Description:This error message appears when you try to use a datatype that is not known and supported by SQL Server. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level […]

An explicit value for the identity column in table ‘%1!’ can only be specified

Error Message:Msg 8101, Level 16, State 1, Line 1An explicit value for the identity column in table ‘%1!’ can only be specified Severity level:16. Description:This error message appears when you try to insert a value into a column for which the IDENTITY property was declared, but without having specified a column list in the INSERT […]

Cannot insert explicit value for identity column in table ‘%1!’ when IDENTITY_INSERT is set to OFF.

Error Message:Msg 544, Level 16, State 1, Line 1Cannot insert explicit value for identity column in table ‘%1!’ when IDENTITY_INSERT is set to OFF. Severity level:16. Description:This error message appears when you try to insert a value into a column for which the IDENTITY property was declared, but without having set the IDENTITY_INSERT setting for […]

“%1!”: Temporary views are not allowed.

Error Message:Msg 4103, Level 15, State 1, Line 2“%1!”: Temporary views are not allowed. Severity level:15. Description:This error message appears when you try to create a temporary view, analogue to a temporary table. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 are generated by the user […]

Database ‘%1!’ already exists.

Error Message:Msg 1801, Level 16, State 3, Line 1Database ‘%1!’ already exists. Severity level:16. Description:This error message appears when you try to create a database with a name under which already a database exists on the specific SQL Server instance. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

Column already has a DEFAULT bound to it.

Error Message:Msg 1781, Level 16, State 1, Line 1Column already has a DEFAULT bound to it. Severity level:16. Description:This error message appears when you try to create a DEFAULTconstraint for a column, for which already a DEFAULT constraint was declared. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

More than one column %1! constraint specified for column ‘%2!’, table ‘t’.

Error Message:Msg 8148, Level 16, State 0, Line 1More than one column %1! constraint specified for column ‘%2!’, table ‘t’. Severity level:16. Description:This error message appears when you try within a CREATE TABLE statement to create more than one constraint for one column for which already another constraint of the same kind was declared in […]

The definition for column ‘%1!’ must include a data type.

Error Message:Msg 173, Level 15, State 1, Line 3The definition for column ‘%1!’ must include a data type. Severity level:15. Description:This error message appears when you try to create a column in a CREATE TABLE statement without specifying a datatype for that column. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error […]
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 |