How to find last access date of database in sql server 2000

  • Hi,

    How to find last access date of database in sql server 2000

    Thanks

  • There isn't a good way to do this. It isn't tracked per se, so you can't be sure when someone last used a database.

    If you suspect no one is using a database, set it to auto close, and if it is accessed, an open message will appear in the log. however backups may open the database, so I'm not sure this is that easy.

    You can set up a trace to watch for queries in the database, or you can set it offline, and wait until someone complains.

  • Hi Steve, thanks for your reply.

    Thanks

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

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