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');

See Also