If your query has the For XML Path('') a list of columns is no longer provided in the select statement.

Thu Sep 29, 2011 11:22 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6579

We are aware of this issue. Processing results with XML values (or even describing them) requires setting certain query execution options which differ from the options used by SSMS. We are looking for a solution.