Error 6826

Troubleshooting SQL Server

Troubleshooting

Error 6826

Severity Level 16
Message Text

Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which they belong.

Explanation

The schema may not have sufficient key fields specified.

Action

This can be resolved by adding sql:key-fields annotation.