Export (0) Print
Expand All


Updated: November 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

This topic is not maintained. For the current version, see IS_SRVROLEMEMBER.

Indicates whether a SQL Server login is a member of the specified fixed server role. In Microsoft Microsoft Azure SQL Database, this statement always returns 0.

Syntax Conventions (Azure SQL Database)

IS_SRVROLEMEMBER ( 'role' [ , 'login'] )

Is the name of the server role that is being checked.

Is the name of the SQL Server login to check. The sysname is login with a default of NULL. If no value is specified, the result will be based on the current execution context.

This syntax diagram demonstrates the supported arguments in Microsoft Azure SQL Database.

In Microsoft Azure SQL Database, this statement always returns 0.

For more information about the arguments and the IS_SRVROLEMEMBER statement, see IS_SRVROLEMEMBER in SQL Server Books Online.

© 2015 Microsoft