SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
Server Class
Server Methods
Alter Method
AttachDatabase Method
CompareUrn Method
DeleteBackupHistory Method
Deny Method
DetachDatabase Method
DetachedDatabaseInfo Method
EnumActiveCurrentSessionTraceFlags Method
EnumActiveGlobalTraceFlags Method
EnumAvailableMedia Method
EnumClusterMembersState Method
EnumClusterSubnets Method
EnumCollations Method
EnumDatabaseMirrorWitnessRoles Method
EnumDetachedDatabaseFiles Method
EnumDetachedLogFiles Method
EnumDirectories Method
EnumErrorLogs Method
EnumLocks Method
EnumMembers Method
EnumObjectPermissions Method
EnumPerformanceCounters Method
EnumProcesses Method
EnumServerAttributes Method
EnumServerPermissions Method
EnumStartupProcedures Method
EnumWindowsDomainGroups Method
EnumWindowsGroupInfo Method
EnumWindowsUserInfo Method
GetActiveDBConnectionCount Method
GetConnection Method
GetDefaultInitFields Method
GetPropertyNames Method
GetSmoObject Method
GetStringComparer Method
Grant Method
IAlienRoot.DesignModeInitialize Method
IAlienRoot.SfcHelper_GetDataTable Method
IAlienRoot.SfcHelper_GetSmoObject Method
IAlienRoot.SfcHelper_GetSmoObjectQuery Method
Initialize Method
IsDetachedPrimaryFile Method
ISfcDomainLite.GetLogicalVersion Method
ISfcHasConnection.SetConnection Method
IsWindowsGroupMember Method
JoinAvailabilityGroup Method
KillAllProcesses Method
KillDatabase Method
KillProcess Method
PingSqlServerVersion Method
ReadErrorLog Method
Refresh Method
Revoke Method
Script Method
SetDefaultInitFields Method
SetTraceFlag Method
Expand Minimize
This topic has not yet been rated - Rate this topic

Server.IsWindowsGroupMember Method

SQL Server 2012

Verifies whether the specified Microsoft Windows user account is a member of the specified Windows group.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
public bool IsWindowsGroupMember(
	string windowsGroup,
	string windowsUser
)

Parameters

windowsGroup
Type: System.String
A String value that specifies the Windows group.
windowsUser
Type: System.String
A String value that specifies the Windows user account.

Return Value

Type: System.Boolean
A Boolean value that specifies whether the Windows user account is a member of the Windows group.If True, the Windows user account is a member of the Windows group.If False, the Windows user account is not a member of the Windows group.

Visual Basic

Copy 
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Verify whether a Windows user is a member of a Windows group.
Console.WriteLine(srv.IsWindowsGroupMember( _
"BUILTIN\Administrators", "NT AUTHORITY\SYSTEM").ToString)

PowerShell

Copy 
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")

Write-Host $srv.IsWindowsGroupMember("BUILTIN\Administrators", "NT AUTHORITY\SYSTEM")
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.