Daylight Saving Time 2007—Databases: MS SQL Server 2005 and 2000

MS SQL Overview

Microsoft SQL Server is a database software package. It comes in many sizes, from Express Edition suitable for light use to Enterprise Edition suitable for data-warehousing. A number of applications include the Express Edition during installation and therefore it may be present on machines on which the user didn't explicitly install it.

Impact of Daylight Saving Time Change on this Technology

There is no impact if the customer applies the Windows DST update and is not running Notification Services.

Details: MS SQL Server uses internal timers that work as relative measures from a specific time and therefore are not affected by DST. Other time functions retrieve their information from the Windows API, and will be correct as long as the OS clock is correct. An exception is the Notification Services portion of MS SQL Server 2000 and 2005 which keeps an internal DST table.

Remediation Steps for Customers

Apply the the Windows DST update, either using Windows Automatic Updates or manually from: http://support.microsoft.com/kb/931836.

Notification Services for SQL Server 2000 and 2005:
If you are running Notification Services, you will need to run an update script, unless SQL Server was at SP2 when you installed Notification Services. The script and more information is at: http://support.microsoft.com/kb/931815

Additional Information

More detailed information can be found on Microsoft's Knowledge Base.

SQL Server 2000 and 2005:
http://support.microsoft.com/kb/931836

Notification Services for SQL Server 2000 and 2005:
http://support.microsoft.com/kb/931815

Get Help

IT Service Center
303-735-4357 (5-HELP)
help@colorado.edu