MSSQL DTS2007 Notification Services update

Int he most recent TechNet Flash newsletter, I spied a link to the article How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007. The article mentions the need to update instances of Notification Services. Following the instructions at http://support.microsoft.com/kb/931815/ was relatively painless.

In addition, there are some issues when using the DateAdd and DateDiff functions. The recommended fix is to use GetUtcDate instead of GetDate. I checkes the apps and DTS packages I have written and none were affected.

Geoff
Sr. System Administrator at the University of Vermont

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.