Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijayakumar_svk
Yak Posting Veteran
50 Posts |
 Posted - 2007-03-27 : 16:54:17
|
| I have an database and it has around 1000 stored procedures and some are orphan and not used in the code for ever. Is there is anyway to find out the Sps in SQL server which are not executed for long time.Work smarter not harder take control of your life be a super achiever |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-27 : 18:46:37
|
| I am not sure if there is an easier way. Rename the procs, duck under the table and hide :) ************************Life is short. Enjoy it.************************ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Finding SPS which are not executed long time