I am looking for a stored procedure or other method that will output the permissions on all stored procedures on my SQL server. (I have both SQL2000 and SQL2005 instances). I've been tasked with documenting all of our SQL servers (many) and want to do it more efficiently than pulling the property pages on each and seeing who has what. I've found a great script that gives me SeverName, DB name, Role name and User Name w/ Id and want to create another loop to include stored procedures, the database name where it resides and the permissions on it.
Your help is appreciated!