Hi Grant, your post has been really helpful. I've been doing some reading and have managed to get the following working but I think it's only looking at system processes....

Thanks for your help Adi. It gave me a little more info to work with and I now have a solution.

EXEC sp_addlinkedserver

@server = N'linkedServer',

@srvproduct=N'19.12.xx.xx',

@provider=N'SQLOLEDB',

@datasrc=N'19.12.xx.xx',...

Thanks Carloyn, that did the trick!

I should have been more specific Grant, the problem was not with the first Insert but the second which was selecting XML data. Not really...

Hi Rudy

Thanks for your post. I had trouble with permissions trying to the Master and Target servers solution from Elizabeth. I think what you've suggest is just what I need...

Thanks for your comments Steve. I could go the ASP route but I'd rather not if at all possible. I'll hold out a little longer in the hope an XML/SQL...

As you say the code seems fine and the problem lies in the XML. The strange thing is, I've managed to select the nodes using ASP. Does this give any...

Thanks for your assistance. You've certainly helped me made progress but I'm still not able to select specific nodes. I've done some reading on Xpath and still I've not managed...

Problem download feed attached