I have two databsse residing on two different servers with different usr authentication. I want to join tables between them. Can anybody help me doing so without linking servers which is not supported by remote servers I am using. the example is:-
A. Server = 184.108.40.206
User/PW= misAdmin09 / 8myname8
B. Server = 220.127.116.11
User/PW= misAdmin10 / 9myname9
I want to link these tables on mstEmployee.EmpCode=mstUser.UserCode
Please let me now if it possible to do so without linking servers.
I am giving Select * From 18.104.22.168].splmis0910.dbo.mstemployee but getting error msg as
"Could not find server '22.214.171.124' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers."
Alok K Goyal