To Search for Unused Stored Proc in a Database

Duplicate post
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12400

Madhivanan

Failing to plan is Planning to fail

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.

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 />

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.

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 />