I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

Too many SQL Servers to keep up with? Download a free trial of SQL Response to monitor your SQL Servers in just one intuitive interface."The monitoring in SQL Response is excellent." Mike Towery.