Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Notification Services / September 2006

Tip: Looking for answers? Try searching our database.

Multicast & SMTP question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CoreyB - 11 Sep 2006 16:47 GMT
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??

>From Shyam's book:

"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.
Warren Brunk - 12 Sep 2006 00:27 GMT
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?

Signature

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

>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
[quoted text clipped - 14 lines]
> email to multiple people.  But I don't want other subscribers' data
> visible - only the subscriber meant for the message.
CoreyB - 12 Sep 2006 10:57 GMT
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."

> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/bfdfa945-96cf-43f1-bb5c-3c8648c6519a.htm
>
[quoted text clipped - 36 lines]
> > email to multiple people.  But I don't want other subscribers' data
> > visible - only the subscriber meant for the message.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.