Méthode ServerConnection.IsInFixedServerRole
Tests whether the logon associated with the referenced connection is a member of the specified fixed server role.
Espace de noms : Microsoft.SqlServer.Management.Common
Assembly : Microsoft.SqlServer.ConnectionInfo (en Microsoft.SqlServer.ConnectionInfo.dll)
Syntaxe
'Déclaration
Public Function IsInFixedServerRole ( _
fixedServerRole As FixedServerRoles _
) As Boolean
'Utilisation
Dim instance As ServerConnection
Dim fixedServerRole As FixedServerRoles
Dim returnValue As Boolean
returnValue = instance.IsInFixedServerRole(fixedServerRole)
public bool IsInFixedServerRole(
FixedServerRoles fixedServerRole
)
public:
bool IsInFixedServerRole(
FixedServerRoles fixedServerRole
)
member IsInFixedServerRole :
fixedServerRole:FixedServerRoles -> bool
public function IsInFixedServerRole(
fixedServerRole : FixedServerRoles
) : boolean
Paramètres
- fixedServerRole
Type : Microsoft.SqlServer.Management.Common.FixedServerRoles
A FixedServerRoles object value that specifies the fixed server role to be compared with the logon.
Valeur de retour
Type : System.Boolean
A Boolean value that specifies whether the logon is a member of the specified fixed server role.If True, the logon is a member of the specified fixed server role.If False, the logon is not a member of the specified fixed server role.
Exemples
C#
ServerConnection conn = new ServerConnection();
conn.DatabaseName = "AdventureWorks2012";
Console.WriteLine(conn.IsInFixedServerRole(FixedServerRoles.SysAdmin));
PowerShell
$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
$conn.DatabaseName = "AdventureWorks2012"
Write-Host $conn.IsInFixedServerRole([Microsoft.SqlServer.Management.Common.FixedServerRoles]::SysAdmin)
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Common
Autres ressources
Autorisations des rôles serveur fixes (moteur de base de données)