dwilliscp (6/24/2013)
I am using SQL 2008R2...
SSMS 2012 can go against SQL 2008 R@. I think the setting is in the same place in SSMS 2008 R2. I was just pointing out the version I am using in case they moved it.
Not sure writing it to a xml file is the better option..
It's not writing to an XML file, it's outputting an un-truncated XML document. Then click on the Grid field to open the document where you can review the entire text. This is just for debug purposes, so you can see the un-truncated output.
how about a cursor?
no need to use a cursor...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato