List users with their rights

To list the users with their rights, use below query. You have to system admin (sysadmin) rights to execute this query.

SELECT name,type_desc,is_disabled, create_date FROM master.sys.server_principals

WHERE IS_SRVROLEMEMBER ('sysadmin',name) = 1 ORDER BY name;