| unc27932@yahoo.com 2005-12-13, 9:23 am |
| 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:[color=darkred
]
> 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:
>
|