Content Comparison

USE [master]
GO

EXEC master.dbo.sp_addlinkedserver 
      @server = N'SECURE_LINKED_SERVER', 
	  @srvproduct=N'', 
	  @provider=N'SQLNCLI11', 
	  @datasrc=N'sqlseclab-lsnr1.its.yale.edu', 
	  @provstr=N'Encrypt=yes;Trust Server Certificate=False', 
	  @catalog=N'master'

EXEC master.dbo.sp_addlinkedsrvlogin 
      @rmtsrvname=N'SECURE_LINKED_SERVER',
	  @useself=N'False',
	  @locallogin=NULL,
	  @rmtuser=N'sa',
	  @rmtpassword='########'

GO