SQL Server Errors or Failures Error: 460 to Error: 479

SQLServerF1

 

Error: 460, Severity: 16,
DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 461, Severity: 16,
The TOP or OFFSET operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 462, Severity: 16,
Outer join is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 463, Severity: 16,
Functions with parameters are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 464, Severity: 16,
Functions with side effects are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 465, Severity: 16,
Recursive references are not allowed in subqueries.

Error: 466, Severity: 16,
UNION operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 467, Severity: 16,
GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Error: 468, Severity: 16,
Cannot resolve the collation conflict between “%.*ls” and “%.*ls” in the %ls operation.

Error: 469, Severity: 16,
An explicit column list must be specified for target table ‘%.*ls’ when table hint KEEPIDENTITY is used and the table contains an identity column.

Error: 470, Severity: 16,
The synonym “%.*ls” referenced synonym “%.*ls”. Synonym chaining is not allowed.

Error: 471, Severity: 16,
Only one of the three options, SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB, can be specified.

Error: 472, Severity: 16,
Either a format file or one of the three options SINGLE_BLOB, SINGLE_CLOB, or SINGLE_NCLOB must be specified.

Error: 473, Severity: 16,
The incorrect value “%.*ls” is supplied in the PIVOT operator.

Error: 474, Severity: 16,
Unable to load the computed column definitions for table “%.*ls”.

Error: 475, Severity: 16,
Invalid SAMPLE clause. Only table names in the FROM clause of SELECT, UPDATE, and DELETE queries may be sampled.

Error: 476, Severity: 16,
Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100.

Error: 477, Severity: 16,
Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer.

Error: 478, Severity: 16,
The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.

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

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *