Daylight Savings Time Patch for SQL Server

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  February 20, 2007 at 8:19 am

  #176785

  Is there a DST Patch for SQL Server 2000? Or is the DST Patch just for the Windows 2003 Operating System. We are running SQL Server 2000 Standard Edition (SP3) on Windows Server 2003 Enterprise Edition. Please provide links to DST Patch Information.

  Thanks in advance, Kevin

• B. Shah

  SSC Journeyman

  Points: 92

  More actions

  February 20, 2007 at 8:49 am

  #690678

  I am not sure if this one is applicable for your situation, but here is a Knowledge Base article on it for the SQL 2000:

  http://support.microsoft.com/Default.aspx?id=931815

  -Brad

• vineet Raut

  SSC Eights!

  Points: 813

  More actions

  February 20, 2007 at 8:59 am

  #690683

  There is no patch to be applied to the SQL server, because SQL server relies on the O.S. timmings. Hence the OS patch is sufficient .

  See below article that would Document it

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

  http://support.microsoft.com/kb/931975/en-us

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  February 21, 2007 at 9:33 am

  #690961

  Just in case you do not have the OS patch link:

  http://support.microsoft.com/kb/931836

  Also, this is one of the 'nicer' Windows patches - it does not need a reboot !

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

• Ignas Chilewa

  Mr or Mrs. 500

  Points: 566

  More actions

  February 21, 2007 at 12:53 pm

  #691012

  Notification Services will be affected on both sql2k and sql2k5..

  Please refer to the details and fix at http://support.microsoft.com/kb/931815/en-us

  Ignas Chilewa

  Dublin, Ohio