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