SQL Server Errors or Failures from Error: 9466 to Error: 9518

SQLServerF1

 

Error: 9466, Severity: 16, XML parsing: line %d, character %d, XML namespace xml namespace URI (http://www.w3.org/XML/1998/namespace) must be assigned only to prefix ‘xml’.
Error: 9467, Severity: 16, XML parsing: line %d, character %d, xmlns namespace URI (http://www.w3.org/2000/xmlns/) is reserved and must not be used.
Error: 9480, Severity: 16, XML parsing: line %d, character %d, unsupported xml
Error: 9500, Severity: 16, The data type ‘%.*ls’ used in the VALUE method is invalid.
Error: 9501, Severity: 16, XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable.

Error: 9502, Severity: 16, The string literal provided for the argument %d of the ‘%.*ls’ method must not exceed %d bytes.
Error: 9503, Severity: 16, Errors and/or warnings occurred when processing the XQuery statement for XML data type method ‘%.*ls’. See previous error messages for more details.
Error: 9504, Severity: 16, Errors and/or warnings occurred when processing the XQuery statement for XML data type method ‘%.*ls’, invoked on column ‘%.*ls’, table ‘%.*ls’. See previous error messages for more details.
Error: 9506, Severity: 16, The XMLDT method ‘%.*ls’ can only be invoked on columns of type xml.
Error: 9507, Severity: 16, The XML data type method on a remote column used in this query can not be executed either locally or remotely. Please rewrite your query.
Error: 9508, Severity: 16, The reference parameter given to XMLDT method ‘%.*ls’ was generated from a different XML instance than the one it is being applied to.

Error: 9509, Severity: 16, XMLUNNEST method requires typed xml column with single global element
Error: 9510, Severity: 16, Functionality not yet implemented: XMLNODEREFS cannot use references exposed by views.
Error: 9512, Severity: 16, Xml data type is not supported as a parameter to remote calls.
Error: 9513, Severity: 16, Error processing XML data type method ‘%.*ls’. The following SET options required by XML data type methods are not set: ‘%.*ls’.
Error: 9514, Severity: 16, Xml data type is not supported in distributed queries. Remote object ‘%.*ls’ has xml column(s).
Error: 9515, Severity: 16, An XML schema has been altered or dropped, and the query plan is no longer valid. Please rerun the query batch.
Error: 9516, Severity: 16, XQuery: The name or one of the parts of a multi-part name supplied to %S_MSG(‘%.*ls’) is empty. Empty names cannot be used to identify objects, columns or variables in SQL.
Error: 9517, Severity: 16, XQuery: The name or one of the parts of a multi-part name that starts with ‘%.*ls’ supplied to %S_MSG() is not a valid SQL identifier – it is too long. Maximum length is %d, actual length is %d.
Error: 9518, Severity: 16, XQuery: The name or one of the parts of a multi-part name that starts with ‘%.*ls’ supplied to %S_MSG() is not a valid SQL identifier – it contains invalid characters.

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 *