Tạo linked server

EXEC master.dbo.sp_addlinkedserver @server =  N'PAX',  @provider=N'SQLOLEDB', @datasrc=N'113.160.234.244,62443', @srvproduct=N'Sql2K5'
GO
 
EXEC master.dbo.sp_addlinkedsrvlogin  @rmtsrvname=N'PAX',  @useself=N'False', @locallogin=NULL,  @rmtuser=N'sa', @rmtpassword='Bravo!@#'
GO
 
EXEC master.dbo.sp_serveroption @server=N'PAX', @optname=N'rpc out', @optvalue=N'true'
GO
 
EXEC master.dbo.sp_serveroption @server=N'PAX', @optname=N'rpc', @optvalue=N'true'
GO
 
EXEC sp_linkedservers
GO

DECLARE @_ServerName NVARCHAR(200) = 'PAX'
 
DECLARE @_isConnect INT;
BEGIN TRY
		EXECUTE @_isConnect = sys.sp_testlinkedserver @_ServerName;
END TRY
BEGIN CATCH
	SET @_isConnect = sign(@@error);
END CATCH; 
 
IF @_isConnect <> 0
BEGIN		
	RAISERROR(N'Không kết nối được tới máy chủ!', 16, 1)    
	RETURN;
END