Discover our Clipsal Smart Home packages as seen on The Block 2018

in location


I'm looking for

  • Wholesalers
    • Uncheck All Check All
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    A query to determine whether a SQL Server login is a member of the specified server role

    How to determine if the current (or any) user can perform an action requiring the server role's permissions.

    Product Line
    Microsoft SQL Server
    Database Manager (Power Monitoring Expert)

    SQL Server Management Studio (SSMS)

    A function that can determine if the user belongs to a server role.

    Important: Database Manager uses the same function to check if the login has sysadmin role before opening the application. If the login does not have sysadmin role, it will not open.

    The syntax of a function that returns if the login is part of the specified server role:
    IS_SRVROLEMEMBER ( 'role' [ , 'login' ] )

    role: Is the name of the server role that is being checked. Valid values for role include the following:
    - sysadmin
    - dbcreator
    - bulkadmin
    - diskadmin
    - processadmin
    - serveradmin
    - setupadmin
    - securityadmin

    login: Is the name of the SQL Server login to check.

    Return Value:
    0: login is not a member of role.
    1: login is a member of role.
    NULL: role or login is not valid.

    Usage examples:


    SELECT IS_SRVROLEMEMBER('public', 'report')

    SELECT IS_SRVROLEMEMBER('sysadmin','any_dmain\any_user')
    The above query takes a domain user as the login

    The above query takes the current user as the login

    note: To get complete information about this Transact-SQL statement, click IS_SRVROLEMEMBER.

    note: Refer to FA346468 for a related article.

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance