SQL Users AUDIT procedure
Stored procedure compatible with Microsoft SQL Server 2005 that shows detailed information about database users. The information can be obtained for a specific database or for all databases on your server. The output contains a list of all users from the database(s) with their logins, the roles to witch are assigned, owned schemas, etc. A very useful tool when you try to keep track of all your database�s users or when you want to refresh a database and restore afterwards its original users.