SQL Server Errors

The database ‘%s’ does not exist. Supply a valid database name. To see available databases, use sys.databases.

Error Message:Msg 15010, Level 16, State 1, Procedure sp_detach_db, Line 34The database ‘%s’ does not exist. Supply a valid database name. To see available databases, use sys.databases. Severity level:16. Description:This error message appears when you try to detach a database that is unknown on a particular SQL Server instance. Consequences:The T-SQL statement can be parsed, […]

Column, parameter, or variable #%d: Cannot specify a column width on data type %.*ls.

Error Message:Msg 2716, Level 16, State 1, Line 1Column, parameter, or variable #%d: Cannot specify a column width on data type %.*ls. Severity level:16. Description:This error message appears when you try to specify a width for a column, parameter, or variable, the data type however, not supports such a width specification. Consequences:The T-SQL statement can […]

SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server

Error Message:Msg 2740, Level 16, State 1, Line 1SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server. Severity level:16. Description:This error message appears when you try to switch to a language that is not known by SQL Server. Consequences:The T-SQL statement can be parsed, but […]

A table can only have one timestamp column. Because table ‘%.*ls’ already has one, the column ‘%.*ls’ cannot be added

Error Message:Msg 2738, Level 16, State 2, Line 1A table can only have one timestamp column. Because table ‘%.*ls’ already has one, the column ‘%.*ls’ cannot be added. Severity level:16. Description:This error message appears when you try to create a table with more than one Timestamp columns. Consequences:The T-SQL statement can be parsed, but causes […]

Multiple identity columns specified for table ‘%.*ls’. Only one identity column per table is allowed.

Error Message:Msg 2744, Level 16, State 2, Line 1Multiple identity columns specified for table ‘%.*ls’. Only one identity column per table is allowed. Severity level:16. Description:This error message appears when you try to create a table with more than one Identity columns. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error […]

Identity column ‘%.*ls’ must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable

Error Message:Msg 2749, Level 16, State 2, Line 1Identity column ‘%.*ls’ must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable. Severity level:16. Description:This error message appears when you try to specify an invalid data type for an Identity column. Consequences:The T-SQL […]

Identity column ‘%.*ls’ contains invalid SEED

Error Message:Msg 2752, Level 16, State 1, Line 1Identity column ‘%.*ls’ contains invalid SEED. Severity level:16. Description:This error message appears when you try to specify an invalid value for the seed of an Identity column. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated […]

Identity column ‘%.*ls’ contains invalid INCREMENT.

Error Message:Msg 2753, Level 16, State 2, Line 1Identity column ‘%.*ls’ contains invalid INCREMENT. Severity level:16. Description:This error message appears when you try to specify an invalid value for the increment of an Identity column. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated […]

%hs is terminating abnormally

Error Message:Msg 3013, Level 16, State 1, Line 2%hs is terminating abnormally. Severity level:16. Description:This error message appears when, for example, a database or transaction log backup cannot be completed due to an error. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are generated by […]

Cannot drop database “%.*ls” because it is currently in use.

Error Message:Msg 3702, Level 16, State 3, Line 2Cannot drop database “%.*ls” because it is currently in use. Severity level:16. Description:This error message appears when you try to DROP a database for which open connections exist. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are […]
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 |