thx kaj , he cant throw or raise what he cant intercept.  and he would try to do that or handle it in sp1 if he first gets convinced he...

• This reply was modified 11 months, 3 weeks ago by stan.

my peer believes this scenario has reared its ugly head again.   Something tells me we addressed this once  before by checking a 2nd sql built in count or flag along...

thx Jeff.  He doesnt do any THROWS.

In this case he doesnt have that opportunity in sp2 before control bubbles back up to sp1.

yes he uses xaxt_abort but still at least...

thx jeff.   i believe what we used to solve this went as follows.   i was talking our dba thru this because he has permissions where we wanted it done.  i...

• This reply was modified 11 months, 4 weeks ago by stan.
• This reply was modified 11 months, 4 weeks ago by stan.

thx frederico.   we understand.

i thought i responded to this already.  jeff i dont get what you are saying but a peer claims a synonym for the linked server name itself is forbidden.  i'll...

not sure what you are asking Jeff.   I'm going on the word of someone here who said he tried it and got an error that specifically forbids syns on linked...

thx Brian.   This is really interesting.  In the meantime we have proven that creating a linked server whose name is db1 but plumbing is server1.db1 does work with 0 code...

• This reply was modified 12 months ago by stan.

thx Brian, Jeff, Ken.   I'm reading the polybase thing now.

I didnt think it mattered but now i should mention that server2 is destined for 2022.  Server1 is stuck on 2019...

• This reply was modified 12 months ago by stan.
• This reply was modified 12 months ago by stan.
• This reply was modified 12 months ago by stan.

thx jeff.  we just learned synonyms dont work with (arent allowed on) linked servers.   But something was bothering us and it goes like this...

our theory (from other experiences) is that...

thx ed b.  what if we forget about the surrogate db.   and all we have is what shows below.   can he avoid changes to his code base on db2?

server1 ,...

we arent always the most transparent group but from what i could tell a mismatch of oracle credential info finally got us past the long running open query.   specifically it...

thx jeffrey.  i'd like to restate the problem so that i can follow what you are saying.   and distinguish his code base changes from other changes.

server1 , db1 has dbo.view1.

server2,...

thx, what if he puts a surrogate db on the new server called A.   And it has a view that thru the linked server sends the correct query to A...

• This reply was modified 1 year ago by stan.
• This reply was modified 1 year ago by stan.

thx for making me look again phil.   hidden in all that noise was this nugget which did the trick....