I have been working with some folks attempting to install the Notification
Workflow Solution Accelerator for MOM 2005 on SQL 2005 Notification Services....an
application that was written for the SQL 2000 version of Notification Services.
We are able to perform the installation, ...

I currently receive a notification if my sql backup fails through sql agent.
However, there is always an outside chance that the sql agent is not working
either in which case I have no notification if my backups fail.
Perhaps one can easily write a command prompt code to monitor ...

I hope someone can help me! I have setup triggers on a table, so that when
the table is inserted to or updated, it fires an event to my SSNS application,
which should then send a notification email out.
For some reason, the notifications are not being sent out. I cannot find

can i change the mail suibject according to the data in the notification table
<NotificationClass>
<NotificationClassName>InstantMessageEmailNotifications</NotificationClassName>
<Schema>

I am having a multi-server deployment scenario. my DB Server will
reside in our domain and would run the NS instance windows service . In
other words, my DB server is behind a firewall. Our Web server would be
outside this domain. the web server would host the subscription

   anybody know what this state mean ??
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 767 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION.

What are the differences between 2000 and 2005, or are they relatively the
same?

I am using SQL Server 2000 Notification Services. The notification
instance that I created does not startup automatically when my machine
restarts. I read in some previous posts that due to dependencies on the
SQL Server, the instance might not start before SQL Server is running.

I'm a little confused as to where SSNS gets its date information. If I connect
to my SSNS database on my database server (local), and type "Select GETDATE()",
I get the correct current date.
But, the date information entered in SSNS tables is always offset by an hour.

When you define you subscription rule in the ADF file for a particular
class it ultimately becomes part of a stored procedure (NSFire) that is
called by the generator.
This automatically created stored procedure encapsulates your rule in a

My question is:  in a scale out deployment, where the NS database will sit on
an existing (and already-paid-for) clustered instance of SQL Enterprise
edition 2005, and the distributor/generator Windows service (the NS engine)
sits on a separate server with no SQL on it - does ...

I have a problem with my SQL 2005 NS
I have a script that insert XML values on a table when a database event
happens (create, alter and drop tables, procedures and views). I have
created a new empty DB called TEST, I ran the script against this DB

I want to create an installer package for my SSNS application. Its going
to shipped to a number of clients, and each client will need to customise
the installation to do things like set up local accounts for running the
windows service, specifying the database name and server ...