|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Email message using MS Sql ServerAll,
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. hi
check the xp_sendmail in Sql server -- Show quoteAnsil Satyam ,Hyderabad "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. > > > |
|||||||||||||||||||||||