Daylight Savings Time issues with Notification Services - update your databases!

  • Article

With the coming change to Daylight Savings Time in the United States, you will need to update your NS application databases for NS v2 and NS v2 SP1. For SQL Server 2005 NS, you will need to update your databases for existing applications. SQL Server 2005 SP2 contains a fix to ensure new applications created after applying SP2 do not encounter this problem.

Here is the KB article that includes database scripts you can use to update the time zone information affected by Daylight Savings Time changes.

https://support.microsoft.com/kb/931815/ 

 

SP2 is not available at the time of this post, but it will be prior to the Daylight Savings Time change taking effect.

Take care and good luck,

-Lukasz