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.

 

SQL Server Errors or Failures Error: 334 to Error: 353

SQLServerF1

 

Error: 334, severity 15,
The target table ‘%.*ls’ of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

Error: 335, severity 16,
Function call cannot be used to match a target table in the FROM clause of a DELETE or UPDATE statement. Use function name ‘%.*ls’ without parameters instead.

Error: 336, severity 15,
Incorrect syntax near ‘%.*ls’. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.

Error: 337, severity 10,
Warning: the floating point value ‘%.*ls’ is too small. It will be interpreted as 0.

Error: 338, severity 16,
READEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views, remote tables, and inserted or deleted tables inside triggers.

Error: 339, severity 16,
DEFAULT or NULL are not allowed as explicit identity values.

Error: 340, severity 16,
Cannot create the trigger “%.*ls” on view “%.*ls”. AFTER triggers cannot be created on views.

Error: 341, severity 16,
Replication filter procedures may not contain columns of large object, large value, XML or CLR type.

Error: 342, severity 16,
Column “%.*ls” is not allowed in this context, and the user-defined function or aggregate “%.*ls” could not be found.

Error: 343, severity 15,
Unknown object type ‘%.*ls’ used in a CREATE, DROP, or ALTER statement.

Error: 344, severity 16,
Remote function reference ‘%.*ls’ is not allowed, and the column name ‘%.*ls’ could not be found or is ambiguous.

Error: 345, severity 16,
Function ‘%.*ls’ is not allowed in the OUTPUT clause, because it performs user or system data access, or is assumed to perform this access. A function is assumed by default to perform data access if it is not schemabound.

Error: 346, severity 15,
The parameter “%.*ls” can not be declared READONLY since it is not a table-valued parameter.

Error: 347, severity 16,
The table-valued parameter “%.*ls” cannot be declared as an OUTPUT parameter.

Error: 348, severity 16,
The table variable “%.*ls” can not be passed to a stored procedure with the OUTPUT option.

Error: 349, severity 16,
The procedure “%.*ls” has no parameter named “%.*ls”.

Error: 350, severity 16,
The column “%.*ls” does not have a valid data type. A column cannot be of a user-defined table type.

Error: 351, severity 16,
Column, parameter, or variable %.*ls. : Cannot find data type %.*ls.

Error: 352, severity 15,
The table-valued parameter “%.*ls” must be declared with the READONLY option.

Error: 353, severity 16,
Function ‘%.*ls’ is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. This is because the function performs user or system data access, or is assumed to perform this access. By default, a f

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.