Find last access

  • Hi all,

    I need to attempt to find out when the last time a particular database was accessed by anyone. Given that there are no 'special' logging processes (and certainly no traces) carrying on on this server/database, and the transaction logs will not help unless the last user changed something (and if it's being used at all it will be 99+% for reference only), I'm not sure it's possible. Only want a ball-park figure, can't find anything useful in event viewer. Any thoughts?

    Thanks in advance.

  • As you already suspected, In SQL2000, there's not much you can do.

    If all your databases have the database recovery model set to "FULL" instead of "SIMPLE", you could use a log reading program to find anything that had changes in each database.

    I'm sure the logs would not have any info from where people did simple SELECT statements and then stopped using the database. that's not logged.

    Otherwise, you'd need to start running a trace to capture login information , so you could capture it going forward, but not based on past data.

    In 2005, there's a lot you can do with triggers and auditing.


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Sadly that's pretty much what I'd concluded. Thanks anyway for giving it some thought.

Viewing 3 posts - 1 through 2 (of 2 total)

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