How to Configure Mail In sql server 2008

How to create and send mail in SQL Server 2008 OR Configure Database Mail - Send Email From SQL Database...

I am going to show you how to send mail using sql server 2008 R2..

Step-1:

Step-2:

 Step -3:

Step-4:

Step-5:

Step-6:

Step-7:

Step-8:

Step -9:

Step -10:

After the Account and the Profile are created successfully, Configure the mail by writing following code

sp_CONFIGURE 'show advanced', 1 

GO 

RECONFIGURE 

GO 

sp_CONFIGURE 'Database Mail XPs', 1 

GO 

RECONFIGURE 

GO 

Step-11:

USE msdb 

GO 

EXEC sp_send_dbmail @profile_name='DotnetHelper', 

@recipients='bikram.sahoo1988@gmail.com', @subject='DotNet Helper',

@body='Dotnet Helper is to help developers upon webapplication.'

You can check the mail by writting following query

use msdb

SELECT * FROM sysmail_mailitems