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 지원 받기