How to find when the database was last accessed?

• farushaik

  Mr or Mrs. 500

  Points: 533

  More actions

  May 31, 2013 at 5:13 am

  #147848

  Hi,

  We have a lot of SQL 2000 databases and planning to decommission the ones which are not used anymore. Is there a way to find when the databases were last accessed or which login used the database?

• Snigdha Vartak

  Default port

  Points: 1486

  More actions

  August 20, 2013 at 1:26 pm

  #1643211

  Please refer http://www.sqlservercentral.com/Forums/Topic1280879-1550-1.aspx