You can create subscriptions and if there is never an event that
satisfies the match rule, no notifications will be produced. For
example, if I create a subscription that says I'd like to be notified
when a certain stock exceeds $1billion / share, I'll probably never
However, if you'd like to prevent a subscriber from being notified
even if a match rule would create a notification, you can disable the
subscriber and/or the subscription.
But if you question is whether or not you can quash a notification
after it is created but before it is delivered, the answer is no, not
that I'm aware of, not without doing something in the delivery
protocol to toss the notification.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Tue, 28 Mar 2006 20:43:02 -0800, Shashidhara
<[email protected]> wrote:
> I would like to know whether it is possible to have a "subscription"
>and yet "not send a notification" to a "subscriber". I so, how do I achieve
>Thanks in advance.