in location

OR

I'm looking for

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

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Powerhouse 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

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

    Product Line
    SQL Server
    Database Manager (PME 8.2)

    Environment
    SQL Server Management Studio (SSMS)

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

    Resolution
    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('sysadmin','ION')

    SELECT IS_SRVROLEMEMBER('public', 'report')

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

    SELECT IS_SRVROLEMEMBER('sysadmin')
    The above query takes the current user as the login

     

    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