LinkedServer Class

아티클
12/15/2008

A LinkedServer object represents a database system other than Microsoft SQL Server and is linked to the current instance of SQL Server using an OLE DB driver.

네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

구문

‘선언
Public NotInheritable Class LinkedServer
    Inherits NamedSmoObject
    Implements ICreatable, IDroppable, IAlterable, IScriptable

public sealed class LinkedServer : NamedSmoObject, ICreatable, IDroppable, IAlterable, 
    IScriptable

public ref class LinkedServer sealed : public NamedSmoObject, ICreatable, IDroppable, IAlterable, 
    IScriptable

public final class LinkedServer extends NamedSmoObject implements ICreatable, IDroppable, 
    IAlterable, IScriptable

public final class LinkedServer extends NamedSmoObject implements ICreatable, IDroppable, 
    IAlterable, IScriptable

주의

이 네임스페이스, 클래스 또는 멤버는 Microsoft .NET Framework 2.0 버전에서만 지원됩니다.

To get LinkedServer object properties, users can be a member of the public fixed server role.

To set LinkedServer object properties, users must have ALTER ANY LINKED SERVER permission on the server or be a member of the sysadmin fixed server role.

To create or drop a linked server, users must have ALTER ANY LINKED SERVER permission on the server or be a member of the sysadmin fixed server role.

To enumerate tables or columns on the linked server, users must have SELECT permission on the schema.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.SmoObjectBase
     Microsoft.SqlServer.Management.Smo.SqlSmoObject
       Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Smo.LinkedServer

예

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

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

LinkedServer Members
Microsoft.SqlServer.Management.Smo Namespace

Share via