http://weblogs.asp.net/bdesmond/archive/2004/02/20/77391.aspxI'm curious how other people do this. I can't figure out how to easily check the output of an SPROC which does a FOR XML. I tried copying the textual output to VS and then hitting the format code button, but there's some sort of wrapping issue, so theenCommunityServer 2007 SP1 (Build: 20510.895)http://weblogs.asp.net/bdesmond/archive/2004/02/20/77391.aspx#77417Sat, 21 Feb 2004 01:30:00 GMTc06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:77417Phil WeberPhil WeberTry executing &quot;dbcc traceon(257)&quot; (without the quotes) before your FOR XML sproc.<img src="http://weblogs.asp.net/aggbug.aspx?PostID=77417" width="1" height="1">http://weblogs.asp.net/bdesmond/archive/2004/02/20/77391.aspx#77398Sat, 21 Feb 2004 00:44:00 GMTc06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:77398Julien CHEYSSIALJulien CHEYSSIALI call the sproc using code, reads the XML from the datareader and then save it on disk :)<img src="http://weblogs.asp.net/aggbug.aspx?PostID=77398" width="1" height="1">