Welcome to MSDN Blogs Sign in | Join | Help

Musings on Reporting Services and Notification Services

My name is Lukasz Pawlowski. I am a Program Manager on the Reporting Services team. I am responsible also for the Notification Services product. I'll use this blog to share some sample code, discuss any common questions I get around either RS or NS. Hope this is useful to you. Send me feedback and I'll try to tailor the content to what you folks are looking for.
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.

http://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

 

Posted: Tuesday, February 13, 2007 9:00 AM by lukaszp

Comments

Porkstone said:

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?

# March 15, 2007 1:01 PM
Anonymous comments are disabled
Page view tracker