Last time the database was touched

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  December 28, 2010 at 6:23 am

  #148031

  Hi,

  I need to find out the last time when all the databases were touched on a particular instance. So using FOREACHDB, how do i do it?

  Thanks.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  December 28, 2010 at 6:52 am

  #1266707

  You can make use of the Default Trace to get that information. Here is a good example.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  December 28, 2010 at 7:48 am

  #1266730

  Thanks that helped.