SQL Server 2000/2005 and DST changes


In August of 2005 the United States Congress passed the Energy Policy Act, which changes the dates of both the start and end of daylight saving time (DST).

When this law goes into effect in 2007, DST will start three weeks earlier (2:00 A.M. on the second Sunday in March) and will end one week later (2:00 A.M. on the first Sunday in November) than what had traditionally occurred.

MS products impacted by this change

You can view a list of all Microsoft products that are impacted by this change here.

Impact on SQL Server

At the time of writing this article, only Notification Services is impacted by this change.

Microsoft has published a KB to help you ease the transition. It highlights the steps needed to be performed in Notification Services to accommodate this change.

Other than NS, please make sure your OS is patched as per the instructions here.


Please check this page at least weekly to ensure you have the latest information available.


Posted by : Sanchan Saxena