Here is something that I found on the FOR XML issue that a few have mentioned:
http://www.sqlservercentral.com/Forums/Topic853088-149-1.aspx
It seems that it may be related to unicode characters.
I am curious, for those that have this issue, Adam Machanic has a proc that he listed in this thread already. Does his proc handle the FOR XML correctly for you?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events