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 |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2008-04-08 : 10:40:40
|
| I'm looking to remove hundereds of legacy procs, triggers, functions etc in a DB. Is there a DMV, sys.<something> command or technique that will tell me the last night an object was accessed or executed? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-08 : 23:02:49
|
| Not as I know of, you need trace them in profiler or set kind of auditing. |
 |
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2008-04-09 : 05:03:07
|
| OK - Thanks for the feedback, .. this jobs going to take longer than originally planned |
|
|
|
|
|
|
Discovery technique for last execution stamp