title: Listing users and their roles in SQL Server
body: <p>I want to get a list of all the users in the SQL server database and their roles. What I'm trying to do is to find out if certain users have privileges to more than one database. Is there a query which can do this directly? </p>