how to use sqlmail

This may seem like stupid question but I have been plinking at this for a
while with no success so I have to ask:
On a machine running win2k server and sql2k, what is required to make
SQLmail work?
Is an example procedure available?
Does it use the desktop owners email client or can it use the servers
IIS SMTP?Some links to how-to and troubleshooting articles, as well as alternatives:
http://www.aspfaq.com/2403
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mmac" <no@.thank.you> wrote in message
news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...

quote:

---

> This may seem like stupid question but I have been plinking at this for a
> while with no success so I have to ask:
> On a machine running win2k server and sql2k, what is required to make
> SQLmail work?
> Is an example procedure available?
> Does it use the desktop owners email client or can it use the servers
> IIS SMTP?
>
>

---

|||I browsed a bunch of the links you sent (thank you BTW) and it appears
that there isn't a way to use the smtp server built into IIS. All examples
use an email client. to send mail. I would prefer to use iis for this at
this moment. Alas...
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Some links to how-to and troubleshooting articles, as well as

---

alternatives:

quote:

---

> http://www.aspfaq.com/2403
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "mmac" <no@.thank.you> wrote in message
> news:#LX20Ix3DHA.2544@.TK2MSFTNGP10.phx.gbl...
a[QUOTE]
make[QUOTE]
servers[QUOTE]
>

---

|||You can use any SMTP server with the CDO and, more appropriately, the
xp_smtp_sendmail procedure referenced in the same article.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mmac" <no@.thank.you> wrote in message
news:ew8Tzox3DHA.1052@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I browsed a bunch of the links you sent (thank you BTW) and it appears
> that there isn't a way to use the smtp server built into IIS. All

---

examples

quote:

---

> use an email client. to send mail. I would prefer to use iis for this at
> this moment. Alas...
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:Ou5J8Mx3DHA.560@.TK2MSFTNGP11.phx.gbl...
> alternatives:
for[QUOTE]
> a
> make
> servers
>

---

|||I guess I mis-browsed. It looked like it had to connect through a client
instead of simple drop . I'll look at it again. Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OK4TItx3DHA.1936@.TK2MSFTNGP12.phx.gbl...

quote:

---

> You can use any SMTP server with the CDO and, more appropriately, the
> xp_smtp_sendmail procedure referenced in the same article.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "mmac" <no@.thank.you> wrote in message
> news:ew8Tzox3DHA.1052@.TK2MSFTNGP12.phx.gbl...
appears[QUOTE]
> examples
at[QUOTE]
> for
>

---