Sql Server Permissions Auditor helps audit permissions on your Sql Server 2005 and up database. The software will audit permissions on tables, stored procedures, and look for several patterns of concern in stored procedures. It requires admin permissions to run.
The first alpha release is coming VERY shortly. Stay tuned!