Here is the way where
we can send email using SQL server, it’s not require any coding and useful
tools to send mail. Here are the steps.
Step 1: Click on Management
after successfully connected with SQL Server 2008, go to the Database Mail and
right click Configure Database Mail
Step 2: Click next to see select Configuration Task screen by
selected option (by default) of Set up Database Mail by performing Mail first
time, select the setup option
Step 3: Click next to see new Profile with profile name and
description, click add to add new profile into database screen, you will see
Add account to profile screen ‘XYZ’. Where you need to enter your email server
details with SMTP and port no
Step 4: click next, next to see unit successful screen come
Step 5: Right click on Database Email and Send Test Email,
below screen will appear. Click on send email to send the email one dialogue
box will appear click on OK. Now you are finished.
Step 6: to check the log files of send email you need to run
the below query in your query analyzer window
use msdb
select * from
sysmail_mailitems
Comments