We have installed SSNS in an active-passive SQL cluster.  All seems to go
well until the SQL group moves to the 2nd server.  At that time, the NS
service fails to start and the group fails back over to the 1st server where
the NS service starts successfully.

I have 3 subscrip events and 3 notification classes.  All the
notifications are using the same notification class.  I specify the
output channel in the sql subscrip.  But i dont see where to add the
notif class in sub.

In a previous posting, Shyam Pather stated that
"Overall, you should be aware that SQL-NS was specifically designed to
scale
well in high-volume applications. It has been deployed successfully in

to use clustering and Multicast for SSNS.
Are there any other benefits that I might be missing? Scallability,
reliability,...?

When we deploy our SSNS instance, the SSNS windows service that gets
created has a startup type of "manual" by default. We'd like to change
that to "automatic" so that it always starts up when the PC is
rebooted. Is there an option to control that?

Im glad I came across this group.
I really need help on SSNS for a very important project. I need to use the xml data type for my notifications, but cannot find any resources on how I can use it, extract data from it or format it.
Here is an example of an event xml structure i need ...

I will be using a non hosted Event Provider to 'push' events into the NS
app. IT will be done using the three stored procedures NSEventBeginBatch,
NSEventWrite, and NSEventFlushBatch written into  UPDATE and INSERT triggers
on the tables in question. I can confirm that the ...

Where do I go to configure the SQL 2000 Notification Services.  We support
an application which integrates with notification services and we cannot
setup any new database scheme's due to a maximum number of events.  I have
no idea where to go on the server to configure this?

I am setting up a Subscription class with two parameters; let's call them P1
and P2. However, the subscribers would like to have multiple combinations of
these two parameters. In other words, if they want 4 possible values for P1
and 3 possible values for P2, then they would need ...

Can some pass on the URLs for learning NS step by step with a very small and
easy example.
I tried going through the NS tutorial (Weather) present in the BOL, but when
i open "NSTutorial.ssmssln" it gives following error:

I have to appoligize...I had started this question in a different Group and
have been re-directed to this one...
Does anyone know how I can use Notification Services to create a Windows
Instant Message that will be sent to an individual whenever a new record is

We are exploring the idea of using Notification Services (SQL 2005)
and we found out that the out of the box delivery protocol is SMTP.
Our mail server is set up not to relay SMTP requests. Do you know how
much of a trouble would be to create custom delivery prococol using

Good morning all:
I would like some book recommendations for a novice @ Noification Services
2005.
Thanks,

Hi, I have setup SQL 2K5 notification application with event and scheduled
notification through email. Everything seems all right. Email notification
can be sent.
When an event is generated, event email notification fire immediately and

Anyone know how to change the quantum duration without have to rebuild
NS? We have a production NS and would like to increase the quantum
duration for scheduled subscriptions.
Thanks