List of Store Procedures Called

Hi

I want to know the Store Procedures called when i run my application.We want to disable / drop the store procedures that are not called. Is there any Trace Template available to do so . We ar e using Sql Server 2000

thanks

You can run the Profiler for that:

File->New->Trace, then in Events tab choose "Stored procedure" event classes, then select only "SPtarting event" and remove others ->Run

After a period of time->Stop selected trace (red button)