Create a Linked Server in SQL Server

You can establish a link to the remote SQL Server using this code:

 Sp_addlinkedserverSyntax :SP_addlinkedserver[@Server]='server'[,[Srvproduct=]'product_name'[,[@provider=]'provider_name'][,[@datascr=]'data_source'][,[location=]'location'[,[@provstr=]'Provider_string'[,[@catalog=]'catalog']server:         Name of the linked server to createproduct_name:   Product name of te OLE DB data sourceProvider_name:  The unique,friendly name for the OLE DB providercorresponding to this data sourcedata_source:   Name of data sourcelocation:      location of databaseprovider_string: The OLE DB provider stringcatalog:   The Catalog name (In SQL Server is database name)example :Connecting to remote SQL Server


If you are connecting to a server that is running SQL Server 7.0, the only arguments that must be provided are the ‘provider_name’ and ‘server’ arguments. Other arguments are used automatically.

 EXEC sp_addlinkedserver 'Accountingserver','SQL server'


‘Accountingserver’ is the server name and ‘SQL server’ is the provider name.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: