Chris Stauffer at myITForum.com

SQL Server 2000 and 2005 not directly affected by DST but...

Just got this from my TAM: 

SQL Server 2000 and 2005 use the DST information from the OS.  One of the add-on components however, Notification Services, will require an update.  Below are the details. 

DST 2007 KB for SQL Notification Services http://support.microsoft.com/?id=931815

The general recommendation is to patch the OS with the DST 2007 update first, then apply the SQL script included in the KB article.

Notification Services (NS) is a component which is not installed by default.   NS is used for initiating messages and notifications to end users from SQL, such as ones to a mobile phone.

The KB article applies to the following versions of Microsoft SQL Server Notification Services:

How to identify if NS 2000 (also known as NS 2.0) or NS 2005 is installed on a machine -

NS 2.0 (aka NS 2000)

=====================

a. This will show up under Add/Remove Programs as "Microsoft SQL Server Notification Services 2.0 SP1"

Add/Remove Programs looks at this key -   HKEY_CLASSES_ROOT\Installer\Products\26ABA4AB609E2B94EBB48C824974CA02

Under this key, if you goto SourceList\PackageName you will find the name as - "Microsoft SQL Server Notification Services 2.0 SP1.msi"

b. Alternatively, once installed, it is at HKLM\Software\Microsoft\NotificationServices which will give you the version and path as well

HKLM\Software\Microsoft\NotificationServices\InstalledVersions\2.0.3008.0 - "C:\Program Files\Microsoft SQL Server Notification Services\v2.0.3008.0\Bin"

(Note - 2.0.3008.0 = SP1)

NS 2005

========

a. It will NOT appear separately under Add/Remove programs (unlike in SQL 2000)

b. You will find it under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup

c. If you want to know where it is installed, the "SQLPath" under the key will tell you -

   SQLPath - C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\

d. Version will tell you whether it is RTM or SP1 -

        For RTM,
        Version = 9.00.1399.06

        For SP1,
        Version - 9.1.2036.00

=========