SQL Server Errors

The %ls statement conflicted with the %ls constraint “%.*ls”. The conflict occurred in database “%.*ls”, table “%.*ls”%ls%.*ls%ls.

Error Message:Msg 547, Level 16, State 0, Line 6The %ls statement conflicted with the %ls constraint “%.*ls”. The conflict occurred in database “%.*ls”, table “%.*ls”%ls%.*ls%ls. Severity level:16. Description:This error message appears when you try to perform a DML statement which conflicts with an existing constraint. Consequences:The T-SQL statement can be parsed, but causes the error […]

The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.

Error Message:Msg 478, Level 16, State 0, Procedure MyOrder, Line 5The TABLESAMPLE clause cannot be used in a view definition or inline table function definition. Severity level:16. Description:This error message appears when you try to use the TABLESAMPLE clause inside a view or inline table function. Consequences:The SQL statement cannot be parsed and further execution […]

Table and column names must be supplied for the READTEXT or WRITETEXT utility.

Error Message:Msg 182, Level 15, State 1, Line 5Table and column names must be supplied for the READTEXT or WRITETEXT utility. Severity level:15. Description:This error message appears when for a READTEXT or WRITEXT command either table- or column name is not supplied. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of […]

The xml data type cannot be compared or sorted, except when using the IS NULL operator.

Error Message:Msg 305, Level 16, State 1, Line 2The xml data type cannot be compared or sorted, except when using the IS NULL operator. Severity level:16. Description:This error message appears when you try to group by a column of the data type XML. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

The valid range for MAX_QUEUE_READERS is 0 to 32767.

Error Message:Msg 187, Level 15, State 1, Line 6The valid range for MAX_QUEUE_READERS is 0 to 32767. Severity level:15. Description:This error message appears when you specify an invalid number for the MAX_QUEUE_READER option during a CREATE/ALTER QUEUE statement. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity level 15 […]

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Error Message:Msg 306, Level 16, State 2, Line 2The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Severity level:16. Description:This error message appears when you try to group by a column of the data type TEXT, NTEXT, or IMAGE. Consequences:The T-SQL statement can be […]

An INSERT statement cannot contain a SELECT statement that assigns values to a variable.

Error Message:Msg 199, Level 15, State 1, Line 0An INSERT statement cannot contain a SELECT statement that assigns values to a variable. Severity level:15. Description:This error message appears when you try to use an INSERT statement that contains a SELECT statement, in which values are assigned to a variable. Consequences:The SQL statement cannot be parsed […]

Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error Message:Msg 307, Level 16, State 1, Line 1Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist. Severity level:16. Description:This error message appears when you try to specify an index that does not exist in an index hint. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]

Operand type clash: %ls is incompatible with %ls

Error Message:Msg 206, Level 16, State 2, Line 1Operand type clash: %ls is incompatible with %ls Severity level:16. Description:This error message appears when you try to use two incompatible operands in an operator. 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 […]

The data types %s and %s are incompatible in the %s operator.

Error Message:Msg 402, Level 16, State 1, Line 3The data types %s and %s are incompatible in the %s operator. Severity level:16. Description:This error message appears when you try to use an operator with incompatible values of incompatible data types for this operator. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. […]
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 |