Find list of Database databases offline with when it was set offline in SQL 2000 on multiple Servers

• ramgck

  SSC Veteran

  Points: 265

  More actions

  February 24, 2012 at 7:35 am

  #100013

  Hi

  i would like Find list of Database databases offline with when it was set offline in SQL 2000 on multiple Servers, can anyone have query to find this?

• sengeet86

  Ten Centuries

  Points: 1252

  More actions

  February 24, 2012 at 11:57 am

  #1451538

  is "c2 Audit mode" enabled on your server?? if yes then you can find it in trace files... else try to find it out in sql error log.

  java programming