|
Home > Archive > MS SQL Server Notification Services > January 2006 > Re: Email confirmation? Bounced email? What to do?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Email confirmation? Bounced email? What to do?
|
|
| unc27932@yahoo.com 2005-12-12, 8:25 pm |
| I can see how the subscriber management interface could add them as a
disabled subscriber, but then how to manage the email of the link,
enabling, etc.? Should I create just another notification application,
just to track & notify new subscribers with their confirmation link?
So for example, I would have one NS instance & two NS applications.
One application is for my actual business need. The other is simply a
new subscriber app. The user signs up for a subscription to what they
think is the business app, but behind the scenes, I actually add them
to my "new subscriber" app. This addition triggers a confirmation
email to the other app.???? Sorry - I'm more of a DB guy, not
applicaiton, or programming. But I appreciate any help you could
offer.
My management is mainly concerned about 1) subscriber management & 2)
bandwidth/bad & expired emails
unc27932@yahoo.com wrote:[color=darkred
]
> By "bad mail drop" do you mean the windows SMTP service? I'm sending
> this mail out to the same SMTP server that handles all outgoing mail,
> and it's not running on Windows ( I don't believe). I'm not sure
> there's an interactive way to scan through that SMTP gateway to check
> out that stuff. And of course we don't want to do it manually.
>
>
> kate wrote:
| |
| Joe Webb 2005-12-13, 3:23 am |
| The URL in the email could be something like:
http://www.mycompany.com?uid=subscriberid
When the user clicks on the link, it would take them to a site that
would read the querystring parameter and ask the user if they'd really
like to subscribe. If they click yes, then you enable the subscriber
using the SQLNS api.
HTH...
--
Joe Webb
SQL Server MVP
http://www.sqlns.com
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On 12 Dec 2005 16:11:19 -0800, unc27932@yahoo.com wrote:
[color=darkred]
>I can see how the subscriber management interface could add them as a
>disabled subscriber, but then how to manage the email of the link,
>enabling, etc.? Should I create just another notification application,
>just to track & notify new subscribers with their confirmation link?
>So for example, I would have one NS instance & two NS applications.
>One application is for my actual business need. The other is simply a
>new subscriber app. The user signs up for a subscription to what they
>think is the business app, but behind the scenes, I actually add them
>to my "new subscriber" app. This addition triggers a confirmation
>email to the other app.???? Sorry - I'm more of a DB guy, not
>applicaiton, or programming. But I appreciate any help you could
>offer.
>
>My management is mainly concerned about 1) subscriber management & 2)
>bandwidth/bad & expired emails
>
>
>
>unc27932@yahoo.com wrote:
| |
| Joe Webb 2005-12-13, 9:23 am |
| Since it's rather straightforward and doesn't involve matching rules,
etc, I'd go with Database Mail for the initial confirmation emails.
HTH...
--
Joe Webb
SQL Server MVP
http://www.sqlns.com
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On 13 Dec 2005 06:00:34 -0800, unc27932@yahoo.com wrote:
[color=darkred]
>I get the concept of that. However, I'm mainly wondering how to
>automate the confirmation emails? Do I just treat that as a separate
>notification rule/event or something? Or maybe just use plain
>"Database Mail" for the initial confirmation email? And then once
>they're enabled, kick in with NS email?
>
>
>Joe Webb wrote:
| |
| Andy Wilbourn 2006-01-04, 11:23 am |
| How is your application giving the user a front end to request an account?
That would be very easy to add the sending of the initial emal confirmation
there. If they are not already a subscriber, then create them as disabled.
The confirmation page that confirms the user will have the logic to enable
the subscriber.
Bad emails is some other process that has to be developed which would call
NS to disable if needed. May be nothing completely different, but I did not
see this suggestion to put it in your management interface.
<unc27932@yahoo.com> wrote in message
news:1134482434.149053.84260@g49g2000cwa.googlegroups.com...
>I get the concept of that. However, I'm mainly wondering how to
> automate the confirmation emails? Do I just treat that as a separate
> notification rule/event or something? Or maybe just use plain
> "Database Mail" for the initial confirmation email? And then once
> they're enabled, kick in with NS email?
>
>
> Joe Webb wrote:
>
|
|
|
|
|