Skip to content

Instantly share code, notes, and snippets.

@sskset

sskset/linked-server.sql

Created June 21, 2019 01:47
Show Gist options
  • Save sskset/7fb7fa3c7c1f32c4c9190a66265948be to your computer and use it in GitHub Desktop.
Save sskset/7fb7fa3c7c1f32c4c9190a66265948be to your computer and use it in GitHub Desktop.
Download ZIP
create a linked server in sql server
Raw
linked-server.sql
-- Create linked server
DECLARE @database VARCHAR(200) = DB_NAME();
EXECUTE sp_addlinkedserver @server = 'Logging',
@srvproduct = ' ',
@provider = 'SQLNCLI',
@datasrc = @@SERVERNAME,
@catalog = @database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment