Last database access

Question

Post reply

Last database access

Paritosh-412771

SSC Veteran

Points: 233
More actions
February 9, 2010 at 6:42 am

#96891

Hi All,
There has been new assingment that has come up by the client to find the list of the database that was last accessed in sql server 2000.
As far as I know there is NO way to find this out, apart from just verifying through windows explorer. THe last modified date option.
have any one has a solution on this..
Help will Appreciated...
Thanks in advance...
Regards
Paritosh...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

By last accessed do you mean last modified or just reading it?

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Johan Bijnens SSC Guru Points: 135375 More actions · Answer 2

If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.

This way, you will find a "database opened" message in your sqlserver errorlog file

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

ALZDBA (2/9/2010)
If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.
This way, you will find a "database opened" message in your sqlserver errorlog file

I would be better looking at the active sessions through Activity Monitor rather than setting that option. Since it would have an impact on the Performance..