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

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  January 19, 2012 at 3:28 pm

  #100432

  Hi,

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

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  January 23, 2012 at 7:18 am

  #1437087

  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.

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  January 24, 2012 at 4:43 am

  #1437578

  Hi Steve, thanks for your reply.

  Thanks