lundi 7 décembre 2015

How to use linkedserver

How can I link two server using query in SQL? I want to remotely query the table of this Server (BL4/SQLEXPRESS) to my Server (BLSVR11). Can you show me how to do it in SQL? This is how I did it but it giving me an error..

EXEC master.dbo.sp_addlinkedserver 
@server = 'BL4\SQLEXPRESS',
@srvproduct = '', 
@datasrc = '192.168.1.1',
@provider = 'SQLNCLI10', 
@provstr = ''

EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'BL4\SQLEXPRESS',
@useself = 'false',    
@rmtuser = 'ID',
@rmtpassword = 'passwd'

SELECT * FROM [BL4].[dbo].[T_Order]

Aucun commentaire:

Enregistrer un commentaire