SQL Server Performance

House keep store procedure + Table with last access date time

Discussion in 'SQL Server 2005 General Developer Questions' started by yhchan2005, Sep 12, 2010.

  1. yhchan2005 Member

    Hi,
    currently i have 200+ store procedure in my database and i know a lot of them is no more using by program. may i know whether SQL server has a log to keep what is the last access date time for each store procedure ???? or any one can let me know whether any way to house keep it ???
    thanks
    yhchan2005, Sep 12, 2010
    #2

  2. Luis Martin Moderator

    Check:
    http://blog.sqlauthority.com/2007/08/10/sql-server-2005-find-stored-procedure-create-date-and-modified-date/
    http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24023428.html
    HTH
    Luis Martin, Sep 13, 2010
    #3

  3. satya Moderator

    It becomes laborious over a period of time, in this case you might look at using server side trace by capturing the SP events to see what are used and what aren't.
    satya, Sep 20, 2010
    #4

Share This Page