← Tutti gli articoli

Sql Server link another Server ( Linked Server )

16 maggio 2011  · TSQL · Recipe  ·  303 visite

How to create a Linked Server (remote) and execute a Select from the local database

 EXEC sp_addlinkedserver
@server=N'REMOTESQLSERVER',
@srvproduct=N'',
@provider=N'SQLNCLI',
@datasrc=N'.';
or
EXEC master.dbo.sp_addlinkedserver @server = N'SVRDB04', @srvproduct=N'SQL Server'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'SVRDB04',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
EXEC master.dbo.sp_addlinkedsrvlogin rmtsrvname=N'SVRDB04',@useself=N'False',@locallogin=N'INTRANET\giovanni.maragna',@rmtuser=N'sa',@rmtpassword='########'



SELECT * FROM REMOTESQLSERVER.DATABASENAME.dbo.TABLENAME
where id_TABLENAME=22