October 2, 2013 at 9:57 pm
Dear,
I require that after processing some transactions, need to send email with necessary information to the respective email addresses.
I am using SQL Server 2008 R2. How can I do it?
Please any guideline/resource must help me.
Regards,
Akbar
October 2, 2013 at 11:20 pm
http://technet.microsoft.com/en-us/library/ms190307.aspx
look up "sp_send_dbmail" in BOL, or read the article...
October 4, 2013 at 1:24 am
First you need to define an email profile and a SMTP account. In the Object Explorer of SSMS, open the Management folder then double-click on Database Mail to open the Database Mail Configuration Wizard. Select "Set up Database Mail ..." and provide the necessary information for the new email profile and SMTP account.
When this is done, you can call the sp_send_dbmail stored procedure to send emails from SQL Server (see BOL for the arguments that must be provided to the stored procedure).
October 4, 2013 at 4:23 am
thank you, pietlinden.
I got ur link the most useful.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply