Last time database was used

• rkaria

  Ten Centuries

  Points: 1363

  More actions

  February 7, 2012 at 4:44 am

  #267955

  Hi all

  I would to know when a user last used a database via ssms, is there a way to do this?

  Either when a last record was entered or something?

  We have a piece of software and one of the databases has not been used for a while, but we just want to double check users are not using it any more, is there a way to do this?

  Thanks

  R

• sqldba4u

  Hall of Fame

  Points: 3414

  More actions

  February 7, 2012 at 5:16 am

  #1443686

  If indexes are present in the database, you may find t-sql in http://sqldba.in