Using Linked Servers in SMO

A linked server represents an OLE DB data source on a remote server. Remote OLE DB data sources are linked to the instance of SQL Server by using the LinkedServer object.

Remote database servers can be linked to the current instance of Microsoft SQL Server by using an OLE DB Provider. In SMO, linked servers are represented by the LinkedServer object. The LinkedServerLogins property references a collection of LinkedServerLogin objects. These store the logon credentials that are required to establish a connection with the linked server.

OLE-DB Providers

In SMO, installed OLE-DB providers are represented by a collection of OleDbProviderSettings objects.



How to: Link to an OLE-DB Provider Server in Visual Basic .NET


获取 SQL Server 2005 帮助