SQL Server Errors or Failures Error: 408 to Error: 438

SQLServerF1

 

Error: 408, severity: 16,
A constant expression was encountered in the ORDER BY list, position %i.

Error: 412, severity: 16,
The column “%.*ls” is not updatable because it is derived or constant.

Error: 413, severity: 16,
Correlated parameters or sub-queries are not supported by the inline function “%.*ls”.

Error: 414, severity: 16,
UPDATE is not allowed because the statement updates view “%.*ls” which participates in a join and has an INSTEAD OF UPDATE trigger.

Error: 415, severity: 16,
DELETE is not allowed because the statement updates view “%.*ls” which participates in a join and has an INSTEAD OF DELETE trigger.

Error: 416, severity: 16,
The service queue “%.*ls” cannot be directly updated.

Error: 417, severity: 16,
TOP is not allowed in an UPDATE or DELETE statement against a partitioned view.

Error: 418, severity: 16,
Objects exposing CLR type columns are not allowed in distributed queries. Use a pass-through query to access the remote object ‘%.*ls’.

Error: 421, severity: 16,
The %ls data type cannot be selected as DISTINCT because it is not comparable.

Error: 422, severity: 16,
Common table expression defined but not used.

Error: 423, severity: 16,
Xml data type methods are not supported in check constraints. Create a scalar user-defined function to wrap the method invocation. The error occurred at table “%.*ls”.

Error: 424, severity: 16,
Xml data type methods are not supported in computed column definitions of table variables and return tables of table-valued functions. The error occurred at column “%.*ls”, table “%.*ls”, in the %ls statement.

Error: 425, severity: 16,
Data type %ls of receiving variable is not equal to the data type %ls of column ‘%.*ls’.

Error: 426, severity: 16,
The length %d of the receiving variable is less than the length %d of the column ‘%.*ls’.

Error: 427, severity: 20,
Could not load the definition for constraint ID %d in database ID %d. Run DBCC CHECKCATALOG to verify the integrity of the database.

Error: 428, severity: 16,
Insert bulk cannot be used in a multi-statement batch.

Error: 432, severity: 16,
Xml data type methods are not supported in check constraints anymore. Please drop the constraint or create a scalar user-defined function to wrap the method invocation. The error occurred at table “%.*ls”.

Error: 434, severity: 16,
Function ‘%ls’ is not allowed in the OUTPUT clause.
Error: 435, severity: 16,
Xml data type methods are not supported in computed column definitions. Create a scalar user-defined function to wrap the method invocation. The error occurred at column “%.*ls”, table “%.*ls”, in the %ls statement.

Error: 438, severity: 16,
Xml data type methods are not allowed in rules. The error occurred at table “%.*ls”.

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 *