Using Tables from Different connections

[bakershawnm]

Hello all,

I currently have 2 sql servers running. Both are 2005. I have some active live information on server1 and some on server2 (I jumped the gun on porting my stuff over before the other DBM got his over). I need to connect some views on server2 to tables/views on server1. I have both servers connected in my SSMS.

First, is it even possible to reference another server from within a view? For example a view on server2 would look like this, "Select * from <server1>.<somedb>.dbo.<sometable/view>"

Second, how would I reference it?

Thanks

 

[bakershawnm]

I found what I need here I think.

thread183-1612065

 

[bakershawnm]

it was actually a combination of the above thread and this:

SELECT *
FROM OPENQUERY([server1], 'Select * from <somedb>.dbo.<sometable/view>') AS derivedtbl

Thanks goes to George from that other thread.

 

[gmmastros]

You're welcome.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom