SQL Server Errors or Failures Error: 2108 to Error: 2211



Error: 2108, Severity: 15, Cannot %S_MSG %S_MSG on ‘%.*ls’ as the target is not in the current database.,
Error: 2110, Severity: 15, Cannot alter trigger ‘%.*ls’ on ‘%.*ls’ because this trigger does not belong to this object. Specify the correct trigger name or the correct target object name.,
Error: 2111, Severity: 16, Cannot %S_MSG trigger ‘%.*ls’ on %S_MSG ‘%.*ls’ because an INSTEAD OF %s trigger already exists on this object.,
Error: 2112, Severity: 16, Cannot create trigger ‘%.*ls’ on view ‘%.*ls’ because the view is defined with CHECK OPTION. ,

Error: 2113, Severity: 16, Cannot %S_MSG INSTEAD OF DELETE or INSTEAD OF UPDATE TRIGGER ‘%.*ls’ on table ‘%.*ls’. This is because the table has a FOREIGN KEY with cascading DELETE or UPDATE.,
Error: 2114, Severity: 16, Column ‘%.*ls’ cannot be used in an IF UPDATE clause because it is a computed column.,
Error: 2115, Severity: 16, Server level event notifications are disabled as the database msdb does not exist.,
Error: 2116, Severity: 16, Cannot CREATE EVENT NOTIFICATION to database ‘%.*ls’ because it is not a valid broker database.,
Error: 2117, Severity: 16, Cannot %S_MSG INSTEAD OF trigger ‘%.*ls’ on %S_MSG ‘%.*ls’ because the %S_MSG has a FILESTREAM column.,
Error: 2201, Severity: 16, %sDerivation from “anySimpleType” by restriction is not permitted, and derivation by restriction from a type derived from “anySimpleType” by extension is allowed only if no constraining facets are specified.,

Error: 2202, Severity: 16, %sAn error has occurred while compiling the query. To obtain more detailed information about the error, the query must be run by a user with EXECUTE permissions on the xml schema collection used in the query.,
Error: 2203, Severity: 16, %sOnly ‘http://www.w3.org/2001/XMLSchema#decimal?’, ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed as predicates, found ‘%ls’,
Error: 2204, Severity: 16, %sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’,
Error: 2205, Severity: 16, %s”%ls” was expected.,
Error: 2206, Severity: 16, %sNamespace prefix ‘xml’ can only be associated with the URI ‘http://www.w3.org/XML/1998/namespace’ and this URI cannot be used with other prefixes.,
Error: 2207, Severity: 16, %sOnly non-document nodes can be inserted. Found “%ls”.,
Error: 2208, Severity: 16, %sThe URI that starts with ‘%ls’ is too long. Maximum allowed length is %d characters.,
Error: 2209, Severity: 16, %sSyntax error near ‘%ls’,
Error: 2210, Severity: 16, %sHeterogeneous sequences are not allowed: found ‘%ls’ and ‘%ls’,
Error: 2211, Severity: 16, %sSingleton (or empty sequence) required, found operand of type ‘%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.

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 *