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 |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2005-03-01 : 12:59:12
|
| Does anyone have a good way of seeing the last date used on all SPs, Views and functions. So that you could clean out any that are unused. JimUsers <> Logic |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-01 : 13:08:34
|
| I assume it's..[quoute]Does anyone have a good way of seeing [/quote]The only way I know is to start a trace in profiler...Brett8-) |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-01 : 14:14:36
|
| I am trying to clean up procedures that have probably not been used in over a year.JimUsers <> Logic |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-01 : 14:15:32
|
maybe you could check the transaction logs?Go with the flow & have fun! Else fight the flow  |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-03-01 : 16:01:46
|
| Drop them all and see who complains.Damian |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-02 : 07:51:25
|
| Damian I would like to drop a few on their heads!I could change all the Sp's to update a log table. There are only about 500.JimUsers <> Logic |
|
|
|
|
|
|
Cleaning up Dead Procedures