I am developing a multi user application using Delphi.  Currently I am using
a database engine that is terrible.  I am considering switching over to SQL
Server.  One of the features that I could really use is for the client
applications to be notified when data changed.  That is, ...

I've developed a custom formatter component to transform complex XML
documents, and get the following error when trying to use it:
<NotificationServicesEvent>
<Description>

I am testing Notification Services and the SQL Server Event Provider.
It is working fine.  The only thing that is confusing me is the times
reflected in the NS tables depending on how I query them.
Three events were added at 12:47:52 PM Eastern Time.

Is there a place to get the information that is stored in the
NotificationState for NotificationHeaders? Since all attributes are marked
as internal we cannot get that information out.
We are trying to build a MQ component and have Shyam's book, but we would

We have a sproc that dynmaically sends email to users via xp_sendmail.
For a variety of reasons, we want to use SNS. However, our subscribers
are dynamically generated in the sproc itself. Is there a way to
replace the subscriber model w/in SNS and still have events fire?

My messages are going through successfully via SMTP, but the To field does
not show the email address of the person. If you look at the SMTP message
with notepad you see X-Receiver: <email address>, but there is not a To:
field declared.

I just inherited a sql server and database to support.  Can anyone tell me
of a sql course that does not include all of the network administrator stuff
also.  I just need to learn the ends and outs of sql management.
Thanks,

I'm new to SQL and setup a backup job.  I setup my internet email address as
the person to notify when back completes.  When I do the test I get the
following error:
Error 22022 SQLServer Agent Error:  THe SQLserveragent mail session is not

I'm having trouble with the NS<product>Events table not being cleaned down.
Initially I thought it was because the vacuum event was clashing with the
backup procedure on the server, so I moved the vacuum event to a time 5
hours before hand.  Unfortunatley it made no difference, and ...

Is it possible to send out HTML emails with embedded images? If so, how can
this be accomplished?
Cheers
Joe

I have installed SQL Notification Services w/ SP1 in my environment, as well
as the MOM 2005 Notification Workflow Solution Accelerator. I am receiving
an error relating to the rule firing. The detailed error message is listed
below. Any advise as to next step in troubleshooting ...

when CDO fails in the standard SMTP protocol assembly provided in NS,
only the outer exception message is reported which is not very useful
as the .net class is interopped to the com cdo class. you get the usual
rubbish about 'subject of invocation failed' which covers almost any

I am trying to find out why my chronicle is getting a double entry for each
event. I am loading via a trigger into the view. Has anyone else had a
problem like this, or give any debugging advice here?
Thanks.

Attempt 2 to post, first one did not seem to go through:
This is a duplicate from the post found at
https://forums.microsoft.com/msdn/ShowPost.aspx?PostID=78223, but just
seeming where it gets answered first.

I've read Shyam's book and the section on updates possibly failing (p. 576
on).  It mentions two subscription tables that must be restored if a
subscription schema changes.  And that you should in general backup the NS
DB's before any schema-changing update.  But the restore ...