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.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.