rbarryyoung (4/11/2008)
Matt: unfortunately, I do not actually have any control over this XML, as it is a Microsoft error message returned by Service Broker. I just quickly mocked the SET = up for folks to test with and while I was trying to get the freakin' angle brackets to show up, I forgot about the embedded apostrophes.So I cannot modify it's creation in any way, I just have to deal with it after I receive it, whic is supposed to be extracting the Error Description and returning it in a RAISERROR message.
*sigh* I really hate XML some days.
Barry - just came across this interesting little ditty:
select cast(@xml.query(N'declare namespace
brokerns="http://schemas.microsoft.com/SQL/ServiceBroker/Error";
(/brokerns:Error/brokerns:Description/text())[1]') as nvarchar(255))
It came out of this document. Again - I hate the documentation on XMl handling in 2005. Just plain SUCKS....
http://msdn2.microsoft.com/en-us/library/ms166041.aspx
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?