SQL 2012 Linked servers

יום ראשון, דצמבר 16, 2012

sp_addlinkedserver (Transact-SQL) Creates a linked server. A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created by usingsp_addlinkedserver, distributed queries can be run against this server. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed. Syntax sp_addlinkedserver 'server' 'product_name' ]      'provider_name' ]      'data_source' ]      'location' ]      'provider_string' ]      [ , [ @catalog=...
תגובה אחת