Must we patch SQL Server to accomodate upcoming DST changes?

Question

Post reply

Must we patch SQL Server to accomodate upcoming DST changes?

Bill Wagman

SSCommitted

Points: 1763
More actions
January 23, 2007 at 6:11 pm

#62796

Greetings,
I have looked at the documentaiton from microsoft regarding the upcoming changes to the Daylight Savings Time date changes. As far as I can tell, as long as the O/S is patched SQL Server will handle the date changes correctly. I would appreciate any feedback others may have on thiws question.
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

dclark SSC Eights! Points: 843 More actions · Answer 1

Microsoft will only be producing patches for XP, Vista, and 2003 Server. There will be no patches for Windows 2000.

Preparing for daylight saving time changes in 2007

http://www.microsoft.com/windows/timezone/dst2007.mspx

How to configure daylight saving time for the United States in 2007:

http://support.microsoft.com/?kbid=914387

Here is a link a free utility that will handle the DST time zone updates for windows machines running XP, NT, 2000, 2003, Vista. It updates Daylight Saving Time in these time zones:

-Alaska Standard Time Zone

-Central Standard Time Zone

-Eastern Standard Time Zone

-Mountain Standard Time Zone

-Pacific Standard Time Zone

-Atlantic Standard Time Zone (Canada)

-Newfoundland Standard Time Zone (Canada)

http://www.intelliadmin.com/blog/2007/01/unofficial-windows-2000-daylight.html

Sample command for silent install from command line:

DaylightSavingFix.exe /qinstall

Bill Wagman SSCommitted Points: 1763 More actions · Answer 2

Greetings, I am a bit confused, at one point you state there will be no patches for Windows 2000 and later list patches including those for Windows 2000. Still my question, will there be specific patches for SQL Server or will updating the O/S take care of the problems?

Thanks.