Export (0) Print
Expand All

IS_SRVROLEMEMBER (Azure SQL Database)

Updated: November 21, 2014

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

ImportantImportant
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'] )

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

login
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.

Show:
© 2014 Microsoft