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 |
|
yhchan2005
Starting Member
26 Posts |
 Posted - 2010-09-13 : 02:39:34
|
| Hi,currently i have 200+ store procedure in my database and i know a lot of them is no more using by program. may i know whether SQL server has a log to keep what is the last access date time for each store procedure ???? or any one can let me know whether any way to house keep it ???thanks |
|
|
CSears
Starting Member
39 Posts |
Posted - 2010-09-13 : 13:32:21
|
| [url]http://www.databasejournal.com/features/mssql/article.php/3687186/Monitoring-Stored-Procedure-Usage.htm[/url]Here is a link that contains some detailed information on how to track some metrics on Store Procedure use. |
 |
|
|
|
|
|
House keep store procedure + Table with last acces