Note: Most of the Article of this blog has taken from another reputated blogs,Websites so Author will not responsible for any Issue.

How to configure dbmail in sql server 2005 and 2008

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: