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 |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2003-11-11 : 10:57:42
|
| Hey all-I've got a database that is not used very often and would like to track when it was last accessed and who it was?Thanks,Doug |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-11 : 11:23:28
|
| You would have to have implemented some form of auditing on the DB. Either columns that track the usage, or tables (Populated by triggers) that audit the DB. Or perhaps c2 auditing (Not sure about that one, never used it).-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Track table usage??