Post reply

Is Notification Services Installed ?

  • February 1, 2007 at 2:59 pm

    #153412

    Is there method to determine if Notification Services is installed? As there about 275 servers running SQL Server 2000 to check, a manual process will not work.

    Specifically, are there registry entries for Notification Services that exist?

    I already have a utility that reads the registry for each of these servers to get the service account for SQL Server and SQL Agent and could easily make changes to read different entries.

    SQL = Scarcely Qualifies as a Language

  • February 1, 2007 at 3:32 pm

    #687244

    Found something on the SQL Server Magazine site:

    For NS2.0 (SQL 2000): If Notification Services is installed on Windows, you will find this registry key:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NotificationServices

    http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=83588&enterthread=y

    Below is a SQL batch that reads the registry and if someone who does have Notification Services is installed could run the SQL and it does find the registry entries, that would be a succesfull test.

    Set nocount on

    Set xact_abort on

    Declare @registrypath varchar(200)

    Set @registrypath = 'SOFTWARE\Microsoft\NotificationServices'

    Exec master..xp_regread 'hkey_local_machine' , @registrypath , 'objectname'

    SQL = Scarcely Qualifies as a Language

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply