bilalhazrvi57 (5/30/2013)
Hi Bills,Thanks a lot for your kind suggestions. Look you told me to do this, that one table from server1 union with one table from server 2. It works quite good, my I am looking for this,
that more than one table from server 1 and more than one table from server 2, is it possible?????
create view gvWDatabase
as
select * from Accounts
union
select * from Account_benefits
union
select * from Lahore.PakistanPostOffice.dbo.Accounts
union
select * from Lahore.PakistanPostOffice.dbo.Account_benefits
Look here the first two tables Accounts and Accounts_benefits are from the server to which currently I am logging and the next two lines
select * from Lahore.PakistanPostOffice.dbo.Accounts
union
select * from Lahore.PakistanPostOffice.dbo.Account_benefits
that two tables Accounts and Account_benefits are from the remote server Lahore which is registered as remote server.
I want to add more than one table from one server and more than one table from 2nd server, is it possible???
Please reply?
If it works for one table from another server, it should definitely work for more than one tables as well 🙂
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/