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 |
|
welford
Starting Member
1 Post |
 Posted - 2010-12-02 : 11:09:35
|
| Hi, I am new to SQL. I am assign to check each DB for usage. In detail last time a table was access, records updated or written to a particular DB etc. Looking to clean up these database and logfile not being used. SQL 2000 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-02 : 11:49:06
|
| You'll need a trace for this (preferably a server-side trace), SQL doesn't store that info anywhere.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Database Updated