in

ASP.NET Weblogs

Brian Desmond's Blog

Inherits Network.Admin
Implements IOneManBand

Testing FOR XML SProcs

I'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 the XML is invalid.
Published Feb 20 2004, 06:22 PM by bdesmond
Filed under:

Comments

 

Julien CHEYSSIAL said:

I call the sproc using code, reads the XML from the datareader and then save it on disk :)
February 20, 2004 7:44 PM
 

Phil Weber said:

Try executing "dbcc traceon(257)" (without the quotes) before your FOR XML sproc.
February 20, 2004 8:30 PM

Leave a Comment

(required)  
(optional)
(required)  
Add