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...
> 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...
> 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...
> > 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?
> >
> >
> >
> >
>|||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...
> 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...
> > 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...
> > > 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 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...
> 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...
> > 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...
> > > 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...
> > > > 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?
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>