Re: Looking to subscribe "roles" rather than "users"
I've been meaning to create a fairly generic custom delivery protocol
using SMTP and post it to my blog, but I haven't made the time for
that as yet. :(
Anyway, Suyog posted one that he created a while back. I haven't used
this one myself so I cannot vouch for it, but it should provide a
Also Shyam Pather has a chapter on it in his book.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On 30 Mar 2006 04:13:05 -0800, "Sprocket" <[email protected]>
>I got the custom delivery protocol to work, but how do I use SMTP in
>this custom delivery protocol? The example sends a notification to the
>Message Queue. How do I implement the use of SMTP to deliver the
>My notification will include a dummy subscription with a roleid and in
>the custom delivery protocol I need to get all memberadresses of a
>role, and then send out emails to each of these members including the
>What do you suggest?
>matt roberts skrev:
>> Hello Sprocket,
>> I've not got there yet, but theres a really good example in Shyams book for
>> custom delivery protocols. Theres some info on msdn too, e.g.:
>> Good luck!
>> > It really looks like a good idea with both dummy subscription and to
>> > do the db lookup in the custom delivery protocol, but do you have an
>> > example of how to do it? I`m not experienced with the custom protocol
>> > and need some tips to implement the solution for notifications to role
>> > members.
|<Prev in Thread]
||[Next in Thread>|
- Re: Looking to subscribe "roles" rather than "users",
Joe Webb <=