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 Querona role that is being checked. role is sysname.
‘login’
Is the name of the Querona 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');