SQL Server Errors

Invalid ROWS value or REPEATABLE seed “%I64d” in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be greater than 0.

Error Message:Msg 479, Level 15, State 0, Line 1Invalid ROWS value or REPEATABLE seed “%I64d” in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be greater than 0. Severity level:15. Description:This error message appears when you try to use an invalid value for the ROWS or REPEATABLE option of the TABLESAMPLE clause. […]

Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause.

Error Message:Msg 482, Level 15, State 2, Line 1Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause. Severity level:15. Description:This error message appears when you try to use a non-constant invalid expression in the TABLESAMPLE or REPEATABLE clause. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

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

The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’.

Error Message:Msg 229, Level 14, State 5, Line 1The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’. Severity level:14. Description:This error message appears when you try to execute an operation on a database object, but you do not have the appropriate permission to execute this operation. Consequences:The T-SQL statement can be […]

Invalid collation ‘%.*ls’.

Error Message:Msg 448, Level 16, State 3, Line 14Invalid collation ‘%.*ls’. Severity level:16. Description:This error message appears when you try to use an unknown collation in a command. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error of the Severity Level 16 are generated by the user and can be fixed by […]

Cannot convert a char value to money. The char value has incorrect syntax.

Error Message:Msg 235, Level 16, State 0, Line 2Cannot convert a char value to money. The char value has incorrect syntax. Severity level:16. Description:This error message appears when you try to convert a non-compatible CHAR value into a value of the type MONEY. Consequences:The SQL statement cannot be parsed and further execution is stopped. Resolution:Error […]

DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error Message:Msg 460, Level 16, State 1, Line 1DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’. Severity level:16. Description:This error message appears when you try to use the DISTINCT operator in the recursive part of a Common Table Expression. Consequences:The T-SQL statement can be parsed, but causes […]
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 |