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



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.

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 *