SQL Server Errors

Could not find stored procedure ‘%1′.

Error Message:Msg 2812, Level 16, State 62, Line 1Could not find stored procedure ‘%1′. Severity level:16. Description:This error message appears when you try to execute a stored procedure, which does not exist in the specified database. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level 16 are […]

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Error Message:Msg 242, Level 16, State 3, Line 3The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Severity level:16. Description:This error message appears, when SQL Server tries to convert a string to a DATETIME value and encounters that the resulting value is outside the valid range […]

Procedure or function %1! has too many arguments specified.

Error Message:Msg 8144, Level 16, State 2, Procedure %1!, Line 0Procedure or function %1! has too many arguments specified. Severity level:16. Description:This error message appears when you try to call a stored procedure and supply more parameters than have been declared for that procedure. Consequences:The T-SQL statement can be parsed, but causes the error at […]

Table ‘%1!” already has a primary key defined on it.

Error Message:Msg 1779, Level 16, State 0, Line 1Table ‘%1!” already has a primary key defined on it. Severity level:16. Description:This error message appears, when you try to create a PRIMARY KEY constraint for a table, for which there is already a PRIMARY KEY declared. Consequences:The T-SQL statement can be parsed, but causes the error […]

Column “%1!.%2!” is invalid in the ORDER BY clause

Error Message:Msg 8127, Level 16, State 1, Line 1Column “%1!.%2!” is invalid in the ORDER BY clause Severity level:16. Description:This error message appears when you try to run an SQL statement, in which you try to sort by a column, that is neither contained in an aggregate function nor in the GROUP BY clause. Consequences:The […]

Cannot add multiple PRIMARY KEY constraints to table ‘%1!’.

Error Message:Msg 8110, Level 16, State 0, Line 1Cannot add multiple PRIMARY KEY constraints to table ‘%1!’. Severity level:16. Description:This error message appears when you try to declare more than one PRIMARY KEY constraint in the same CREATE TABLE statement. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

Invalid column name ‘%.*ls’.

Error Message: Msg 207, Level 16, State 3, Line 1Invalid column name ‘%.*ls’. Severity level: 16. Description:This error message appears when you reference a column in the SELECT list that SQL Server cannot find in any table in the FROM clause. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the […]

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

Percent values must be between 0 and 100.

Error Message: Msg 1031, Level 15, State 1, Line 1Percent values must be between 0 and 100. Severity level: 15. Description:This error message appears when the specified percent value is not within the valid range of 0 through 100. Consequences:The SQL statement can be parsed, but cannot be executed and execution is stopped. Resolution:Error of […]
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 |