On a side note... the XML datatype will not allow itself to be passed as a parameter between linked servers.
Seriously.
You have to pass a VARCHAR(MAX) then shove it into a local XML variable at the target. Microsoft, your inter-server communications decisions continue to boggle me.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA