1. Open Query Analyzer and connect to a database of interest. 2. Open the Object Browser by pressing [F8] or going to Tools | Object Browser on the Query Analyzer menu. 3. Select the stored procedure of interest. 4. Right-click on the stored procedure's name and select Debug from the pop-up menu.
What I meant was, is there really a tool that can measure all aspect of what a stored procedure can perform? Can it measure index use? DDL statements, validate dynamic sql statements? deletes and inserts on linked servers? adding users? dropping tables?