Sql Error #6860, Severity 16

Sql Error Number:6860
Severity: 16

Description: FOR XML directive XMLDATA is not allowed with ROOT directive or row tag name specified.

Possibly related links:

XML Support in Microsoft SQL Server 2005
Also, the new ROOT directive allows a root node to be specified in all modes of FOR XML. ... XML data type methods are not allowed in the Transact-SQL GROUP BY ...

XML Support in Microsoft SQL Server 2005
Also, the new ROOT directive allows a root node to be specified in all modes of FOR XML. ... XML data type methods are not allowed in the Transact-SQL GROUP BY ...

FOR Clause (Transact-SQL)
The XMLDATA directive to the FOR XML option is deprecated. ... If the optional root name is not specified, the default element is added. Examples ...

Using EXPLICIT Mode
Is either the name of the XML attribute (if Directive is not specified) or the ... The first row identifies Tag value 1. All columns with the Tag value 1 are ...

Errors 6000 - 6999
Row tag name is only allowed with RAW or PATH mode of FOR XML. 6860. 16. No. FOR XML directive XMLDATA is not allowed with ROOT directive or row tag name specified. ...

Using EXPLICIT Mode
For Tag column value 1 in the first row, the columns whose names include the ... whereas the xml directive is not allowed with any other directive, except hide. ...

Using EXPLICIT Mode
For Tag column value 1 in the first row, the columns whose names include the ... whereas the xml directive is not allowed with any other directive, except hide. ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!