How to get the available server roles for the sql logins in sql server database

  • In my application, I have to check whether given sql login has server roles like db_creator,public, or serveradmin .. etc.

    How can i check roles information for the given sql login?.

    Whether this information is stored in system tables.?

    I want to know system tables information which contains

    login,server roles, user,default database attached to login, etc

    Can anyone help in this regard?

    Please reply

  • you can query from the syslogins table

    http://rajanjohn.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply