SQL Server Errors

Invalid length parameter passed to the %ls function.

Error Message:Msg 536, Level 16, State 1, Line 3Invalid length parameter passed to the %ls function. Severity level:16. Description:This error message appears, when you call a string function with an invalid length parameter. 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 […]

Could not find any index named ‘%1!’ for table ‘%2!’.

Error Message:Msg 7999, Level 16, State 10, Line 1Could not find any index named ‘%1!’ for table ‘%2!’. Severity level:16. Description:This error message is raised, when SQL Server cannot find the specified index on that table. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity level 16 are […]

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries

Error Message:Msg 1033, Level 15, State 1, Line 5The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified. Severity level:15. Description:This error message appears, when you try to call one of the above mentioned constructs without specifying also TOP or FOR XML. Consequences:The SQL statement cannot […]

‘%.*ls’ is not a recognized %ls option.

Error Message:Msg 155, Level 15, State 1, Line 1‘%.*ls’ is not a recognized %ls option. Severity level:15. Description:This error message appears, when an invalid option was specified for a system supplied function. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level 15 are generated by the user and […]

The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.

Error Message:Msg 1062, Level 15, State 1, Line 2The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause. Severity level:15. Description:This error message appears, when you try to use a TOP n WITH TIES clause without a corresponding ORDER BY clause. Consequences:The SQL statement cannot be parsed and further execution […]

Incorrect syntax near the keyword ‘%.*ls’.

Error Message:Msg 156, Level 15, State 1, Line 2Incorrect syntax near the keyword ‘%.*ls’. Severity level:15. Description:This error message appears, when SQL Server encounters a syntax error. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level 15 are generated by the user and can be fixed by the […]

The %.*ls function requires %d argument(s).

Error Message:Msg 174, Level 15, State 1, Line 1The %.*ls function requires %d argument(s). Severity level:15. Description:This error message appears, when a function is called with the wrong number of arguments supplied. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level 15 are generated by the user and […]

Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls.

Error Message:Msg 245, Level 16, State 1, Line 1Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls. Severity level:16. Description:This error message appears, when SQL Server encounters an error while converting from one type into another type. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

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

The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.

Error Message:Msg 294, Level 16, State 0, Line 1The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error. Severity level:16. Description:This error message appears when you try to convert a string to the SMALLMONEY datatype, but the resulting value is beyond the allowed range for a SMALLMONEY value. Consequences:The […]
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 |