SQL Server Performance

To Search for Unused Stored Proc in a Database

Discussion in 'Performance Tuning for DBAs' started by Sitanshu, Jan 17, 2006.

  1. Sitanshu New Member

    How to search for UNUSED Stored Procedures in a database in SQL Server 2000.

    Sitanshu Gupta
  2. Madhivanan Moderator

  3. satya Moderator

    Please adhere to the forum policies and refer to the referred thread, this post is locked.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. FrankKalis Moderator

    Have you noticed that in this thread he's asking "how to unused Stored Procedures?" while in the other thread he's asking about "How to search for unused <b>tables</b>?"<br /><br />Not quite the same, methinks. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  5. satya Moderator

    I believe the referred link by Madhi about Adam Machanic's process will fetch the results, so it stands as tables & SPs are objects of a database.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. FrankKalis Moderator

    No problem with me. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />

Share This Page