IS_SRVROLEMEMBER
Indicates whether a SQL Server login is a member of the specified server role.
Syntax
IS_SRVROLEMEMBER ( 'role' [ , 'login' ] )
Arguments
' role '
Is the name of the Lyftron role that is being checked. role is sysname.
' login '
Is the name of the Lyftron login to check. login is sysname, with a default of NULL. If no value is specified, the result is based on the current Execution context. If the parameter contains the word NULL will return NULL.
Return types
int
Examples
SELECT IS_SRVROLEMEMBER('diskadmin', 'QEnv\Kriss');