다음을 통해 공유

  • 아티클

Roles 속성

ServerRole 개체의 컬렉션을 나타냅니다. 각 ServerRole 개체는 SQL Server 인스턴스에 정의된 역할을 나타냅니다.

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

구문

‘선언
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(ServerRole))> _
Public ReadOnly Property Roles As ServerRoleCollection
    Get
‘사용 방법
Dim instance As Server
Dim value As ServerRoleCollection

value = instance.Roles

[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(ServerRole))]
public ServerRoleCollection Roles { get; }

[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny, 
    typeof(ServerRole))]
public:
property ServerRoleCollection^ Roles {
    ServerRoleCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(ServerRole))>]
member Roles : ServerRoleCollection

function get Roles () : ServerRoleCollection

속성 값

유형: Microsoft.SqlServer.Management.Smo. . :: . .ServerRoleCollection
SQL Server 인스턴스에 정의된 모든 역할을 나타내는 ServerRoleCollection 개체입니다.

주의

The Roles property points to the ServerRoleCollection object. You can use the collection to reference the fixed server roles the instance of SQL Server.

예

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display the fixed server roles.
Dim sr As ServerRole
For Each sr In srv.Roles
   Console.WriteLine(sr.Name)
Next

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
foreach ($sr in $srv.Roles)
{
   Write-Host $sr.Name
}