I have resolved the 'namespace' issue.

Can anyone direct me to teh right links for the encoding problem. Thanks

Okay, this is my issue now:

Assume that the the parameter for my stored procedure is in this format:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

<ns2:tradesResponse xmlns:ns2="http://www.X.com/xmlschema/response">

<calypsoTradeResult>

<tradeID>138125</tradeID>

<measureResult>

...

I tried including them in the query this way:

select

---

from

---

(select ---

from @XML.nodes ('ns2:Response/Result') Response (Result)) as Responses)

cross apply Results.nodes('/calypsoTradeResult/measureResult')

But it...

Hi,

Can you tell me how I can remove the namespace (ns2) and the <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> in the xml before making this query. Thanks a lot

I got it to work. Thank you, so much

Hi

Thank you. Looks like there is some error some where. I corrected the xml format. However, I am not getting the tradeIds(they are all null). Here is my query

The correct...

Friends,

From your responses, I understand two things:

- Linked servers is the widely used technique for accessing DBs from another instance

- It's not as easy as just prefixing the object's name...

Thanks guys, for the prompt response. Here are the answers to Bru's questions:

- No, the jobs will not move to #instance2. We do not know how many jobs are affected..yet...