Create a Linked Server in SQL Server

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.

See also  How to Avoid Money Transfer Scams  

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist