Home All Groups Group Topic Archive Search About

Email message using MS Sql Server

Author
4 Jan 2006 1:41 AM
Just D.
All,

What is the simplest way to send an email message through the MS SQL Server?

There was a method to send email messages using a standard C# way via SMTP
server, but the required port was blocked on our server for the security
reasons. So there is the only one method that I see to send my messages. The
idea was to send these messages about some critical events, exceptions,
etc., happening with our web application. The mechanism was already written
and working but I need to switch to the MS SQL Server to get it working
again.

Can anybody give any idea, or code, or links? I know that this feature
should be built into the MS SQL Server.

Thanks,
Just D.

Author
4 Jan 2006 5:19 AM
Ansil MCAD
hi

check the xp_sendmail in Sql server
--
Ansil
Satyam ,Hyderabad


Show quote
"Just D." wrote:

> All,
>
> What is the simplest way to send an email message through the MS SQL Server?
>
> There was a method to send email messages using a standard C# way via SMTP
> server, but the required port was blocked on our server for the security
> reasons. So there is the only one method that I see to send my messages. The
> idea was to send these messages about some critical events, exceptions,
> etc., happening with our web application. The mechanism was already written
> and working but I need to switch to the MS SQL Server to get it working
> again.
>
> Can anybody give any idea, or code, or links? I know that this feature
> should be built into the MS SQL Server.
>
> Thanks,
> Just D.
>
>
>

AddThis Social Bookmark Button