http://www.sqlservercentral.com/Scripts tagged Audit posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).http://www.sqlservercentral.com/scripts/Administration/63841/2008/07/24http://www.sqlservercentral.com/scripts/Administration/63841/This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.http://www.sqlservercentral.com/scripts/trigger/63064/2008/06/12http://www.sqlservercentral.com/scripts/trigger/63064/Create journal to audit changes in user tablehttp://www.sqlservercentral.com/scripts/journal/61303/2007/12/12http://www.sqlservercentral.com/scripts/journal/61303/SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script. http://www.sqlservercentral.com/scripts/Audit/61175/2007/11/28http://www.sqlservercentral.com/scripts/Audit/61175/