all groups > sql server notification services > september 2006 >
You're in the

sql server notification services

group:

Multicast & SMTP question


Multicast & SMTP question CoreyB
9/11/2006 8:47:57 AM
sql server notification services:
I have a question that needs clearing up. I know that I do want to use
the multicast feature. Our app is such that we may have thousands of
users subscribed to one specific event, so clearly we don't want to
format thousands of times. We want to format just once, to save
resources.

We are using the SMTP delivery protocol - so my question is: if I send
the same message to 1000 subscribers using multicasting - is this going
to put all of my subscribers' email addresses in the email header??

[quoted text, click to view]

"If the network protocol provides a way to send as single message to
multiple recipients, the delivery protocol can use this facility".

Clearly SMTP allows this - you see it all the time when you send an
email to multiple people. But I don't want other subscribers' data
visible - only the subscriber meant for the message.
Re: Multicast & SMTP question Warren Brunk
9/11/2006 4:27:38 PM
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/bfdfa945-96cf-43f1-bb5c-3c8648c6519a.htm

When multicast delivery is enabled, the delivery protocol receives the
formatted message once with a list of subscriber information. The delivery
protocol must be able to use the recipient list to send the formatted
message to multiple subscribers. It can do this either by sending a single
message, if the network protocol supports true multicast delivery, or by
simply iterating through the subscriber list and sending the same message to
each subscriber.

SMTP - If you use the BCC in Smtp all recipients will be blind the the other
users. A better way might be to iterate through and send one email at a
time.

Does that help?

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


[quoted text, click to view]

Re: Multicast & SMTP question CoreyB
9/12/2006 2:57:13 AM
I'd rather not use BCC - I don't think I need to, based on the BOL
entry you sent me. It looks like I can just enable multicasting.

"Multicast delivery is transparent to subscribers. The actual network
protocol used to send the notification messages does not have to
support multicasting."


[quoted text, click to view]
AddThis Social Bookmark Button