SQL Server Performance Forum – Threads Archive

inactive sps

Actually i am getting problem in my daily work with unused stored procedures they used long back ,there is any way to delete them (i strongly believe there are lot ) without using profiler traces if so please send me a script from any one or any ideas to avoid them SRJ2005

Profiler. Trace event ID 114 & 118, possibly 108. There’s no other way without risking dropping something that does get used.

See if this helps you http://www.pinpub.com/ME2/Audiences…50&tier=4&id=CE9E01AE99334E1CBDC32C150AE6BE08 Madhivanan Failing to plan is Planning to fail

I believe if those are unused stored procedures then there is no harm to the database, as it doesn’t occupy any space at all. May check in the history whether these have been used somewhere sometime. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>