SQL Server Errors

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

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

Error Message:Msg 195, Level 15, State 10, Line 1‘%.*ls’ is not a recognized %S_MSG. Severity level:15. Description:This error message appears, when SQL Server encounters the use of database object in the wrong context. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level 15 are generated by the user […]

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

Error Message:Msg 296, Level 16, State 3, Line 1The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. Severity level:16. Description:This error message appears, when SQL Server cannot convert a character string into a valid SMALLDATETIME value. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

DEFAULT or NULL are not allowed as explicit identity values.

Error Message:Msg 339, Level 16, State 1, Line 2DEFAULT or NULL are not allowed as explicit identity values. Severity level:16. Description:This error message appears, when one tries to explicitely INSERT a NULL marker into a column with the IDENTITY property. The same error is raised, when one tries to enter a value into such an […]

A constant expression was encountered in the ORDER BY list, position %i.

Error Message:Msg 408, Level 16, State 1, Line 1A constant expression was encountered in the ORDER BY list, position %i. Severity level:16. Description:This error message appears, when you try to use a constant expression in the ORDER BY clause. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity […]

Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.

Error Message:Msg 507, Level 16, State 2, Line 3Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer. Severity level:16. Description:This error message appears, when you try to call SET ROWCOUNT with an invalid argument. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the Severity Level 16 are […]

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

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