Post reply

Establishing stored proc usage

  • August 11, 2003 at 11:20 am

    #59303

    Is there any way to tell when the last time a stored procedure was used, and/or how often it is being executed?

    Thanks,

    Jeff


    "Keep Your Stick On the Ice" ..Red Green

  • August 11, 2003 at 11:21 am

    #469449

    Set up a SQL Profiler trace tracking stored procedure statement completion. The trace can be run for a time period and stored to file or a table...more in BOL.

  • August 12, 2003 at 7:44 am

    #469565

    You could set up a log table and have the proc insert a record everytime it is run. Then you could see when and if necessary who ran the proc.

  • August 12, 2003 at 8:01 am

    #469576

    Thanks. I was hoping to avoid either choices 🙂


    "Keep Your Stick On the Ice" ..Red Green

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply