Skip to content

Instantly share code, notes, and snippets.

@petesql
Last active March 3, 2019 22:18
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
configure_linked_servers
-- 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment