configure_linked_servers

configure_linked_servers.sql

-- Configuring Linked Servers (SQL Server). 
USE [master]
GO

-- https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-2017
EXEC master.dbo.sp_addlinkedserver 
	@server = N'PETE-PC', 
	@srvproduct=N'SQL Server'

-- https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-serveroption-transact-sql?view=sql-server-2017
EXEC master.dbo.sp_serveroption 
	@server=N'PETE-PC', 
	@optname=N'connect timeout', @optvalue=N'0'

-- https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedsrvlogin-transact-sql?view=sql-server-2017
EXEC master.dbo.sp_addlinkedsrvlogin 
	@rmtsrvname = N'PETE-PC', 
	@locallogin = NULL , 
	@useself = N'False', 
	@rmtuser = N'linked_login', 
	@rmtpassword = N'epae2!"mdm!'
GO