SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in For XML Path('') prevents assistance      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic For XML Path('') prevents assistance Author Message judahr Joined: 09 Mar 2007 Posts: 319 Country: United States For XML Path('') prevents assistance v6.0.70 Pro MSSQL 2008 R2 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 SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 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. Fri Sep 30, 2011 10:23 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.