SQL Server Performance Forum – Threads Archive
script
how we know which stored procedures are not using in applications may get script for that ? SRJ2005Hi,<br />do u want to know which sp is not used in Application !? i feel its not possible to get it from SQL Server.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br /><br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Post your question at the relevent Forum You should search for the sp name in your Application and find out the list
You should maintain the document for this Otherwise Run the Profiler and run the application fully by executing each screens then see what sps are not shown in the Profiler Madhivanan Failing to plan is Planning to fail
As has been mentioned, please post in the appropriate forum. If you are uncertain, which forum is the "best" for your question, just use the "General…" forum. [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><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 />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
Get the details about indentifying unused Sps fromhttp://www.pinpub.com/ME2/Audiences…50&tier=4&id=CE9E01AE99334E1CBDC32C150AE6BE08 here, good article by Adam Machanic. [moved from General Developer section] 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.
]]>