Identify Ununsed Store Procedure

  • Is there any way to find out the ununsed Store Procedure in sql server

  • Not that I know of.

    SQL Server is pretty skimpy when it comes to this kind of info.  When we migrated from the AS/400, the lack of information about object usage and history what quite startling

  • You can set up a profiler trace watching only stored procedures, with results to table, then you can query the table. There is a small amount of overhead having this task running.

     

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

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