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?