Is an explanation available for why one might get the following error
when starting an instance using the command line:
nsservice InstanceName -a
Microsoft SQL Server Notification Services service executable 9.0.242.0

I would like to create a subscription that once a Notification is generated
for the subscription it becomes disabled.   If there a way to do this
automatically?  If not, any recommendations?
FYI.. We do have our own custom formatter and delivery protocol/channel.  It

Under SQL Server 2005 Standard SP1
Each day between 12:00 AM and 12:01 AM, receive error in SQL Agent log:
"Date        8/22/2006 12:00:59 AM
Log        SQL Agent (Archive #8 - 8/27/2006 4:07:00 PM)

One deployment strategy is to have the SQLNS instance service (NS$) and
event providers running on one server (A) and the database on another
server (B).  My questions are:
1) How should SQLNS behave when servers A and B are rebooted?  My

I am getting this error while running notification services
Message: 4120: The number of events in this quantum is greater than the
throttle specified for events.
Some of the event and subscription views could not be materialized.

I have two databases with same strucutres.
I am able run the notification services for one istance and it is not
working for
second instance of database. First database have 50,000 Records and the

I tried the samples (especially Newsletter sample) and I see how to get
notifications to go via e-mail or to a file.
What I am wondering is how to get an application to listen for them and
consume them.

i am looking on some demos in shyam pathar book on NS 2005 and i look
at the SubscribtionLoader C# code and i see it sets the ScheduleStartTime
property ,i did not find any corresponding setting in the ADF file ,is it
possible

We have a SQL 2k5 notification service application, which is running on Windows 2003 server, couldn't start after we applied the SQL 2k5 sp1. Opened the even viewer, there wasn't any entry found in the logs related to service failure. The server is located in our internal network ...

I found the Flight Sample Description at
http://msdn2.microsoft.com/en-us/library/ms160946(d=ide).aspx .
I installed the file     SQLServerSamples.msi     which is in C:\Program
Files\Microsoft SQL Server\90\Tools\Samples    by default.

Is it proper to create a trigger on delete stored procedure on the NS
subscription table to cleanup any chronicle tables that I have created
for my application ?
When a subscription is deleted, I want to purge data from some

I am attempting to create a simple event chronicle that stores the last run
time, per the example in Shyam's most recent book regarding SQL 2005.
The below snippet is an example of what I have for this chronicle and rule
specifically.

If I have a subscriber set up to look for updates to medical records via a
client application that is running on their machine, is there a delivery
format that will allow me to send a notification directly back to the client
assembly that contains the client subscriber that is ...

I read some theoretical explanation of notification services.
I want to find a source for notification services that has examples of how
to implement notification services from A to Z.
Thank you in advance.

I did search the web for the following question but could not find a
clear answer maybe some one can point me in the right direction.
I downloaded a sample for service broker and set it up between two SQL
Servers and it works just fine. I then recreated the sample between SQL