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: