Daylight Savings Change

• Steve-3_5_7_9

  SSChampion

  Points: 10832

  More actions

  February 7, 2007 at 12:18 pm

  #116199

  From what I've read so far from Microsoft, the only SQL Server 2005 daylight savings issue is with Notification Services.

  http://support.microsoft.com/gp/dst_overview

  Besides the server patch, has anyone heard of any SQL 2005/2000 patch's which need to be applied.

  Thanks

   

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  February 7, 2007 at 1:09 pm

  #688380

  SQL Server gets it's time from the OS, so no patch is needed.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=339222

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=332998

  Greg

• MohammedU

  SSCoach

  Points: 19644

  More actions

  February 7, 2007 at 4:42 pm

  #688429

  How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

  http://support.microsoft.com/default.aspx?scid=kb;en-us;931975&sd=rss&spid=2855

   

  MohammedU
  Microsoft SQL Server MVP

• Steve-3_5_7_9

  SSChampion

  Points: 10832

  More actions

  February 8, 2007 at 4:58 am

  #688509

  Thanks all.

• ram4tech

  Hall of Fame

  Points: 3140

  More actions

  February 8, 2007 at 7:59 am

  #688581

  Is there a way to sign up with Microsoft to get alerts when there is a patch for SQL Server products?

  As I visit this site often, I am glad that I checked this message, otherwise I wouldn't have known beforehand.

  Thanks Mohammed for the URL.

• MohammedU

  SSCoach

  Points: 19644

  More actions

  February 8, 2007 at 4:52 pm

  #688706

  I don't have the URL handy but you can go to microsoft.com and register for updates...

   

  MohammedU
  Microsoft SQL Server MVP