SQL Server 2000/2005 and DST changes
Background
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.
IMPORTANT
Please check this page at least weekly to ensure you have the latest information available.
Posted by : Sanchan Saxena
