Mark B. – tech

SQL Server : Linked Server

What are Linked Servers?

A Linked Server is a Link to an external (remote) data source. The remote data source can be Oracle, Access, Excel or any other data source that uses an OLE DB provider.

Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries.


sp_addlinkedserver [ @server = ] server
[ , [ @srvproduct = ] product_name]
[ , [ @provider = ] provider_name]
[ , [ @datasrc = ] data_source]
[ , [ @location = ] location]
[ , [ @provstr = ] provider_string]
[ , [ @catalog = ] catalog]

Example :

EXEC sp_addlinkedserver @server='S1_instance1',
@srvproduct='', @provider='SQLOLEDB', @datasrc='S1\instance1'

detail of linked server, please visit this web address :

This entry was published on May 30, 2011 at 9:34 am and is filed under IT - Tutorial. Bookmark the permalink. Follow any comments here with the RSS feed for this post.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: