Showing posts with label hican. Show all posts
Showing posts with label hican. Show all posts

Thursday, March 22, 2012

email using

hi
can any one guide me, how to send email using stored procedure in sql server
2000 in windows 2003 o/s without using mail client installed on server.
Thanks
KalyanUse xp_smtp_sendmail, all you need is the ability to install an extended
procedure, and an SMTP server you can control.
http://www.aspfaq.com/2403
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
> hi
> can any one guide me, how to send email using stored procedure in sql
> server
> 2000 in windows 2003 o/s without using mail client installed on server.
> Thanks
> Kalyan
>|||Aaron
My operating system is windows 2003, Is smtp comes with IIS?
Thanks
Kalyan
"Aaron Bertrand [SQL Server MVP]" wrote:

> Use xp_smtp_sendmail, all you need is the ability to install an extended
> procedure, and an SMTP server you can control.
> http://www.aspfaq.com/2403
>
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
>
>|||> My operating system is windows 2003, Is smtp comes with IIS?
IIS has its own SMTP server, so yes, I guess it is compatible. However, you
do not have to have SMTP running on the same server as SQL Server, in fact I
recommend it be separate.