If you are using SQL 2005 you can very easily create a db_executor role that gives SP execute permission to all SPs in a database (including ones created after you...

Indeed, backup your production database, restore it on a non-production machine, and run your tests on that, if at all possible.

You still need to get the traces from the production...

Hi Johnny,

You need to look into running traces in SQL Server Profiler. A trace is basically a record of all the SQL being run on the server together with performance...

There are plenty of free command line zippers that can be found with a simple Google query. Have a look for example at these two:

http://www.7-zip.org/

http://www.freebyte.com/fbzip/

HTH