Add Linked SQL Server

Menyambungkan Dua SQL Server dengan Query

EXEC master.dbo.sp_addlinkedserver
@server = N'APPL01'
, @srvproduct=N'SQL_Server'
, @provider=N'SQLNCLI'
, @provstr=N'PROVIDER=SQLOLEDB;SERVER=APPL01\SQLEXPRESS'
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname=N'APPL01'
, @useself=N'True'
, @locallogin=NULL
, @rmtuser=N'sa'
, @rmtpassword=N'paswrod'
GO