SQL Server Errors

Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”.

Error Message:Msg 240, Level 16, State 1, Line 1Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”. Severity level:16. Description:This error message appears when data types of a column in the anchor and the recursive part of a Common Table Expression are incompatible. Consequences:The T-SQL statement can […]

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

Error Message:Msg 461, Level 16, State 1, Line 1TOP 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 TOP operator in the recursive part of a Common Table Expression. Consequences:The T-SQL statement can be parsed, but causes […]

Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator.

Error Message:Msg 252, Level 16, State 1, Line 1Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator. Severity level:16. Description:This error message appears when a Common Table Expression does not contain a top-level UNION ALL operator. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of the […]

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

Error Message:Msg 462, Level 16, State 1, Line 1Outer join 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 an OUTER JOIN in the recursive part of a Common Table Expression. Consequences:The T-SQL statement can be parsed, but causes […]

Recursive member of a common table expression ‘%.*ls’ has multiple recursive references.

Error Message:Msg 253, Level 16, State 1, Line 1Recursive member of a common table expression ‘%.*ls’ has multiple recursive references. Severity level:16. Description:This error message appears when the recursive part of a Common Table Expression has more than one recursive reference. Consequences:The T-SQL statement can be parsed, but causes the error at runtime. Resolution:Error of […]

Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100.

Error Message:Msg 476, Level 15, State 0, Line 1Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100. Severity level:15. Description:This error message appears when you try to use an invalid percent value in the TABLESAMPLE clause. Consequences:The T-SQL statement can be parsed, but causes the error […]

Must pass parameter number %d and subsequent parameters as ‘@name = value’. After the form ‘@name = value’ has been used, all subsequent parameters must be passed in the form ‘@name = value’.

Error Message:Msg 119, Level 15, State 1, Line 1Must pass parameter number %d and subsequent parameters as ‘@name = value’. After the form ‘@name = value’ has been used, all subsequent parameters must be passed in the form ‘@name = value’. Severity level:15. Description:This error message appears when you try to pass parameters in different […]

Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

Error Message:Msg 273, Level 16, State 1, Line 1Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. Severity level:16. Description:This error message appears when insert an explicit value into a column if type TIMESTAMP. Consequences:The T-SQL […]

Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer.

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

The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Error Message:Msg 128, Level 15, State 1, Line 5The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Severity level:15. Description:This error message appears when you try to use an object name in an invalid context. Consequences:The T-SQL statement can […]

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 |