how to add a linked server

do those steps:

  1. EXEC sp_addlinkedserver ‘srvrname’
  2. if you want to use other credentials: EXEC sp_addlinkedsrvlogin ‘srvrname’, ‘false’, NULL, ‘username’, ‘userpasswort’
  3. after that you can access your desired data: select * from [srvrname].[catalog].[scheme].[tbl]

references:

sp_addlinkedserver
sp_addlinkedsrvlogin

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s