microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Replace subscriber model?

Subject: Re: Replace subscriber model?
From: Joe Webb
Date: Tue, 13 Sep 2005 06:41:19 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
In 2005, you can use some new buillt-in views to create and manage
subscriptions, subscribers, etc. That may offer the flexibility you
are looking for.

-- 
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On 8 Sep 2005 15:36:22 -0700, "kate" <[email protected]> wrote:

>i hope i have interpreted your requirement correctly. you want to send
>an event to NS which will cause it to notify all the recipients defined
>in your sproc.
>
>i think you should be able to use an idea that was in an earlier post.
>In the notifications rule you can join to additional
>views/functions/tables so as to generate multiple outgoing
>notifications for one incoming subscription.
>
>so you could have one 'super subscription' , implement you sproc as a
>function returning a table object with the dynamic subscriber address
>list and join the 2 in the rules.
>
>no need to create/drop any data and you keep control of the dynamic
>list. You could extend this so different 'super subscriptions' caused
>your function to return different lists for future applications.
>
>hope this helps
>
>Kate MBCS
>
>Alert Technologies
>http://www.alert-technologies.co.uk
>Get your notification services implementation going in minutes not
>weeks ......

<Prev in Thread] Current Thread [Next in Thread>