tempdb recreations

• mtz676

  SSCrazy Eights

  Points: 9176

  More actions

  November 1, 2012 at 1:53 am

  #266495

  How do I track all sql server restarts in a domain ?

  Ex:Lets says there are 100 servers.\

  I would like to maintain a database which stores all the server names,server restart start times based on tempdb recreation times.

  Then I would like to create a report of this database.

  Is this possible ?

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  November 2, 2012 at 4:52 am

  #1555392

  SELECT @@SERVERNAME, login_time

  FROM sys.dm_exec_sessions

  WHEREsession_id = 1;

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]