Toreador (5/20/2010)
I ran the script and got an errorError Character '', hexadecimal value 0x0 is illegal in XML documents.
ie the first option, which is not the correct answer.
As well as this error, I also got an XML segment, which I surrounded by a root element. Displaying this in IE gives an error
'an invalid character was found in text context'.
but displays the XML anyway.
Courious.
I'm using ± standard settings of SSMS and of IE too. I hadn't any error message running the query.
You had to have something different.