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

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. 


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,



Comments (1)

  1. Porkstone says:

    Apologies for the OT comment, can you point me to any online resources that will:

    Help me understand the best way to integrate our SQL server based system with RS to serve reports to our clients. We need to send PDF and Excel reports out everyday to 1000’s of clients is RS a good tool for this?

    We would like our system to control which reports are sent out to a client and the parameters that drive the report is this possible?