How to configure dbmail in sql server 2005 and 2008
2:34 AM
Step 1) Create Profile and Account:
You need to create a profile and account using the Configure Database Mail Wizard which can be accessed from the
Configure Database Mail context menu of the Database Mail node in Management Node.
This wizard is used to manage accounts, profiles, and Database Mail global settings which are shown below:
Step 3) Send Email:
After all configurations are done, we are now ready to send an email. To send mail,
we need to execute a stored procedure sp_send_dbmail and provide the required parameters as shown below: