Database mail in sql

03 Sep 2013    by: Sameer Das

Generally we configure mail in fronted ( Now you can also configure mail using SQL (In enterprise version) .

Step 1:
Connect the SQL
Step 2:
Right click on Database mail & click on Configure Database Mail
Step 3:
Then you will get “Configure Database Mail wizard“. & click on Next
Step 4:
Then you will get “Select configuration task” & choose “Setup database mail by performing following task”   (
Step 5:
Then you will get “Select configuration task” & create a  Profile with SMTP account by click on Add button (
Step 6:
Then you will get “New database Mail Account” wizard & create a  Profile with SMTP account by click on Add button (
Step 7:
Fill the all required fields.(
Step 8:
Click Finish & Send a Test mail using sql (