SQL Server Errors or Failures Error: 440 to Error: 459

SQLServerF1

 

Error: 440, severity: 16,
Internal query compilation error. The stack overflow could not be handled.

Error: 441, severity: 16,
Cannot use the ‘%ls’ function on a remote data source.

Error: 442, severity: 16,
The NEST argument must be a column reference. Expressions are not allowed.

Error: 443, severity: 16,
Invalid use of a side-effecting operator ‘%s’ within a function.

Error: 444, severity: 16,
Select statements included within a function cannot return data to a client.

Error: 445, severity: 16,
COLLATE clause cannot be used on expressions containing a COLLATE clause.

Error: 446, severity: 16,
Cannot resolve collation conflict between “%ls” and “%ls” in %ls operator for %ls operation.

Error: 447, severity: 16,
Expression type %ls is invalid for COLLATE clause.

Error: 448, severity: 16,
Invalid collation ‘%.*ls’.

Error: 449, severity: 16,
Collation conflict caused by collate clauses with different collation ‘%.*ls’ and ‘%.*ls’.

Error: 450, severity: 16,
Code page translations are not supported for the text data type. From: %d To: %d.

Error: 451, severity: 16,
Cannot resolve collation conflict between “%ls” and “%ls” in %ls operator occurring in %ls statement column %d.

Error: 452, severity: 16,
COLLATE clause cannot be used on user-defined data types.

Error: 453, severity: 16,
Collation ‘%.*ls’ is supported on Unicode data types only and cannot be set at the database or server level.

Error: 454, severity: 16,
The UNNEST argument must be a nested table column.

Error: 455, severity: 16,
The last statement included within a function must be a return statement.

Error: 456, severity: 16,
Implicit conversion of %ls value to %ls cannot be performed because the resulting collation is unresolved due to collation conflict between “%ls” and “%ls” in %ls operator.

Error: 457, severity: 16,
Implicit conversion of %ls value to %ls cannot be performed because the collation of the value is unresolved due to a collation conflict between “%ls” and “%ls” in %ls operator.

Error: 458, severity: 16,
Cannot create the SELECT INTO target table “%.*ls” because the xml column “%.*ls” is typed with a schema collection “%.*ls” from database “%.*ls”. Xml columns cannot refer to schemata across databases.

Error: 459, severity: 16,
Collation ‘%.*ls’ is supported on Unicode data types only and cannot be applied to char, varchar or text data types.

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 *