I have a fairly large app that is using notifications services ( in
prototyping) .  Basically i use notification services to deliver a
notification via a custom delivery channel ( MSMQ).  Everything works
as required but i have some questions on performance.

My notification system seems to be working fine but on one of my notification
classes the notifications continually have a deliverystatuscode = 0. All
other ones are working fine. Any ideas why this would be?

Apologies if this is considered off-topic, however does anyone know of any
hosting companies that provide good quality service as well as the following
technologies:
MS SQL Server 2005 (with Notification Services)

We would like to take advantage of most of NS 2005's capabilities,
*except* for it's management of subscriptions and subscribers.  (We
have our own custom DB with subscriptions and subscribers.)
My plan for doing this is to create just two subscribers in NS - a

We would like to build a custom content formatter which *extends* the
default XSLT formatter.  In other words, we want all of the
XSLTFormatter's XML transformation functionality, but in addition, we
want it to make a web service call to generate a report and return its

I would like to include a variable in the Subject field of an email sent
from Notification Services. Is there a way to do this? What is the
limitation of the <SQLExpression></SQLExpression> tag in the Protocol? Is
this where I would grab my variable?

i am trying to get sql to send alert job email using 64 bit
I keep reading it can work
Even if i click on sql server agent mail session mail profile i get
18038 sql mail does not work with 64 bit version of SQL Server