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.
Posted: Feb 20 2004, 06:22 PM by bdesmond | with 2 comment(s)
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) 

(required) 

(optional)

(required)