I have two servers

[dass]

I have two servers server1 and server2
I want to fetch records from both server with single query
using Ip address

like :
Select * from * empower_hold where username not in(
select musername From despatch_dtls)

the 1st query is from server1
and 2nd one from server2

please help me

 

[JamesLean]

Look up linked servers in BOL. This enables you to refer to another server simply by qualifying it's name:

SELECT * FROM server_name.db_name.owner.table_name

--James

 

[SQLBill]

I believe you need to use the full name of the database:

servername.database.owner.tablename.columnname

I don't link servers myself, so you might want to look through the BOL for anything on Linked Servers.

-SQLBill

 

[MaffewW]

if you are running the query on server1 (assuming you have ran sp_addlinkedserver 'server2name' and have appropriate permission on the linked server)

Select * from empower_hold where username not in(
select musername From server2.database.databaseowner.despatch_dtls)


Matt

Brighton, UK