Thanks for the response Jack!

So create the temp table in the the shell that executes the remote script, or in the remote script that gets executed? I hope that makes...

Holy cow! Not one response! Not one person even interested in telling me I'm in the wrong forum, or this sort of question doesn't belong here, or I'm a bad...

Thanks for the feedback!

Yea, I hibernate as well until something forces me to reboot (like Windows Update). Then I have to open them all again. It's not that difficult to...

Got it figured out. Thanks!! Definitlely got me over the hump. I've posted the solution in case anybody out there is interested, or if anybody else out there is working...

Sorry, the xml did not make it into the post. Here's the attachment.

That makes a lot of sense, I'm still missing something though. Let's forget about the typed xml for a minute. I don't understand why this returns NULL. The element I'm...

I've been at this all day, and I cannot get one query/value/exist to work against that fairly complicated xml presented in the last post. Does SS5 come up short?...

Actually, I can make this question MUCH simpler. Can anybody demonstrate how to parse a few values out of this document. My attempts are missing the boat somewhere. Here's what...

Sure thing. Sorry. Didn't realize I could do that in this forum.

BTW, here's the error:

Msg 2260, Level 16, State 1, Line 18

XQuery [query()]: There is no element named 'OTA_HotelResNotifRQ'

Thx!

The SQLAgent is setup to use the local system account. It's a simple query that uses multi-part syntax to insert from one server into another:

insert into [10.2.1.50].TargetDb.dbo.TargetTable(f1,f2,f3)

select...

One more thing. Nothing on this DB server is encrypted.

Thx!

Hmm, so you don't think "protocol encryption" would be sufficient?

Thanks for the response.

To answer your question, yes, our app. uses a lot of pass through sql. It also uses a good deal of rdo as well. I'm not sure...

Thanks guys, great solutions. I appreciate Franks "set base" solution. Frank your advice dead on; "name the object yourself". Had I known in advance that TSQL didn't support "alter table drop...

Well, the problem with that is when the table is created, I do a

create table(

TableIdCol...

primaryKey(TableIdCol)

)

So I never know what the primary key will be named at a particiular customer site.