March 4, 2007 at 3:48 pm
Hello Gurus,
How do I check to see if notification services are running?
Thanks.
R
March 5, 2007 at 8:13 am
Notification is one of tasks under SQL Server Agent. My suggestion is: start an alert and see if you are notified.
March 5, 2007 at 8:41 am
Thank you SQL Oracle. I have setup alerts in SQL server 2005, when databases are successfully backed up. So NS is being used on that server. But, how do I check in SQL Server 2000, as it is hard to setup a email alert in 2000.
March 5, 2007 at 9:48 am
You can set up your notification profile. It is not quite easy to build the notification profile on SQL Server 2000. You may use other tools to send email notifications. Some recommended tools are: gbmail and CDONT. Both of them can be download from internet free of charge.
You can use xp_cmdshell to send out your notification.
March 10, 2007 at 6:06 pm
I found this on another discussion forum,
"If you do not have an instance of Notification Services deployed, then you do not have to worry about patching. The binary files of Notification Services are not affected. You have to apply the update only when you create an instance. If there are no services running and no NS* databases, then really nothing to do. Also, for instances deployed after SQL Server 2005 SP2 is installed you do not have to do anything, as instances created with SP2 will have the correct DST info."
Is this true?
And also, there are steps to find out if NS is being used.
http://support.microsoft.com/kb/931815
How to determine whether Notification Services is installed
How to determine whether SQL Server 2000 Notification Services is installed.
To determine whether SQL Server 2000 Notification Services is installed, use one of the following methods:
Method 1
In Control Panel, open the Add or Remove Programs item. If you notice the following entry, the original version of SQL Server 2000 Notification Services is installed:
Microsoft SQL Server Notification Services (2.0.2114.0)
If you notice the following entry, SQL Server 2000 Notification Services Service Pack 1 (SP1) is installed:
Microsoft SQL Server Notification Services 2.0 SP1
Method 2
In Registry Editor, locate the following registry subkey:
HKEY_CLASSES_ROOT\Installer\Products
If you notice the following registry subkey, the original version of SQL Server 2000 Notification Services is installed:
64942737F6AC0D146AF0B91F262A693C
If you notice the following registry subkey, SQL Server 2000 Notification Services Service Pack 1 (SP1) is installed:
26ABA4AB609E2B94EBB48C824974CA02
Method 3
In Registry Editor, locate the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NotificationServices\InstalledVersions
If you notice the 2.0.2114.0 registry subkey, the original version of SQL Server 2000 Notification Services is installed. Also, the Path registry entry of the 2.0.2114.0 registry subkey contains the following value:
\Microsoft SQL Server Notification Services\v2.0.2114.0\Bin
Note The placeholder represents the folder where you install SQL Server 2000 Notification Services.
If you notice the 2.0.3008.0 registry subkey, SQL Server 2000 Notification Services SP1 is installed. Also, the Path registry entry of the 2.0.3008.0 registry subkey contains the following value:
\Microsoft SQL Server Notification Services\v2.0.3008.0\Bin
Note The placeholder represents the folder where you install SQL Server 2000 Notification Services.
How to determine whether SQL Server 2005 Notification Services is installed
To determine whether SQL Server 2005 Notification Services is installed, locate the following registry entry in Registry Editor:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup\Version
If the value is 9.00.1399.06, the original version of SQL Server 2005 Notification Services is installed.
If the value is 9.1.2047.00, SQL Server 2005 Notification Services SP1 is installed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply