SQL Server Errors or Failures from Error: 9519 to Error: 9538

SQLServerF1

 

Error: 9519, Severity: 16, XQuery: The name supplied to sql:variable(‘%.*ls’) is not a valid SQL variable name. Variable names must start with the ‘@’ symbol followed by at least one character.
Error: 9520, Severity: 16, XQuery: ‘%.*ls’ referenced by sql:variable() is not a valid system function name.
Error: 9521, Severity: 16, Error processing XML data type. The XML data type instance contains a negative xs:date or xs:dateTime value.
Error: 9522, Severity: 16, The XQuery modify method is not allowed on sparse column sets.

Error: 9523, Severity: 16, Cannot update the sparse column set ‘%.*ls’ because the XML content supplied references the non-sparse column ‘%.*ls’ which does not belong to this column set. The XML data used to update a sparse column set cannot reference columns that don’t belong to t
Error: 9524, Severity: 16, The XML content provided does not conform to the required XML format for sparse column sets.
Error: 9525, Severity: 16, The XML content that is supplied for the sparse column set ‘%.*ls’ contains duplicate references to the column ‘%.*ls’. A column can only be referenced once in XML content supplied to a sparse column set.
Error: 9526, Severity: 16, In the XML content that is supplied for the sparse column set ‘%.*ls’, the ‘%.*ls’ attribute value on the element ‘%.*ls’ is out of range. The valid range is from 1 to %d.

Error: 9527, Severity: 16, In the XML content that is supplied for the column set ‘%.*ls’, the sqltypes:scale attribute value on the element ‘%.*ls’ is out of range. The valid range for the scale is from 0 to the specified precision.
Error: 9528, Severity: 16, In the XML content that is supplied for the column set ‘%.*ls’, the ‘%.*ls’ attribute on the element ‘%.*ls’ is not valid. The attribute is valid only for sparse columns of data type sql_variant.
Error: 9529, Severity: 16, In the XML content that is supplied for the column set column ‘%.*ls’, the sqlDBType:base64Encoded attribute on the element ‘%.*ls’ is not valid. The base64Encoded attribute can only be used when the corresponding sparse column is of character data type (
Error: 9530, Severity: 16, In the XML content that is supplied for the column set column ‘%.*ls, the ‘%.*ls’ attribute on the element ‘%.*ls’ is not valid. Remove the attribute.
Error: 9531, Severity: 16, In the XML content that is supplied for the column set column ‘%.*ls’, the ‘%.*ls’ attribute value on the element ‘%.*ls’ is not valid.
Error: 9532, Severity: 16, In the query/DML operation involving column set ‘%.*ls’, conversion failed when converting from the data type ‘%ls’ to the data type ‘%ls’ for the column ‘%.*ls’.
Error: 9533, Severity: 16, In the XML that is supplied for the column set ‘%.*ls’, the element ‘%.*ls’ should reside in the global namespace. Remove the default namespace declaration or the prefix on the element.
Error: 9534, Severity: 16, In the query/DML operation involving column set ‘%.*ls’, conversion failed when converting from the data type ‘%ls’ to the data type ‘%ls’ for the column ‘%.*ls’. Please refer to the Books-on-line for more details on providing XML conversion methods for
Error: 9535, Severity: 16, For untyped XML it is not allowed to specify MAXLENGTH or SINGLETON option if XSD type is not already specified for path ‘%.*ls’ of selective XML index ‘%.*ls’.
Error: 9536, Severity: 16, It is not allowed to specify REMOVE ‘%.*ls’ more than once for the same pathname in alter statement for selective XML index ‘%.*ls’.
Error: 9537, Severity: 16, Two paths indexed with selective XML index ‘%.*ls’ on table ‘%.*ls’ would have same path name with new collation.
Error: 9538, Severity: 16, Paths with same path expression indexed with selective XML index ‘%.*ls’ should have SINGLETON option either specified for all of them or for none of them.

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 *