Our app goes through & disables some subscriptions using the NS views
nightly based on some business rules.
        UPDATE    Notify.dbo.NSSubscriptionClassView
        SET        Enabled = 'Disabled'

I am receiving the following error in the application event log file.
It only happens intermittently.  The SMTP server and email addresses
are valid and available at the error times in question.  This error is
followed by a delivery failure message.

When using Sql Cache Dependency with Sql Server 2005 it's my
understanding that you should use Query Notification. My question is
let's say I write a Sql statement with a WHERE clause in it. Does the
cache dependency fire if only the data within that WHERE clause changes

What is the best way to be notified, from SQL Server 2000, that a row was
added, deleted, or modified in another application?
I'm a competent C# developer, but a "babe in the woods" when it comes to SQL
Server.  I have been reading about the Notification "engine" in SQL Server

I need to add dynamic conditions to my subscriptions.
My situation is like this:
Users are presented with a ad-hoc query builder and they can select
upto 10 fields to put in the where clause.

I tried to install the service SQLMail in my SQL2000 Enterprise and give me
this error:
Error 18030: xp_test_mapi_profile: Either there is no default mail client or
the current mail client can not fulfill the messaging request

i am very new to notification service, I just created a instance
notification in sql 2005, and i found it auto created two database , can
anyone explain what's those two database differents?
Cheers

When you install the NS Sample "Flight" where does it draw it's data from? I
only ask because I cant figure out where the tables "Flight" it keeps
querying from exist.
Thanks in advanced

Does anyone know of a more active newsgroup on SQL Notification
Services?  This group has become progressively less used over the past
several months or so.  I'm trying to find some answers to some
questions......