Sunday, July 10, 2011

SQL Server Database Mail Sending Test E-Mail

Run this below SQL Script in the server where you want to test.

Before executing below query change the "profile_name" as per your profile name and change the recipients with your mail ID. 

Here is the script for testing database mail.
EXEC msdb.dbo.sp_send_dbmail 
@profile_name='Default Database Mail',
@recipients='name@google.com',
@subject = TEST,
@body = TEST,
@body_format = 'HTML' ;
Troubleshooting Database Mail. Sending Test E-Mail. Troubleshooting Database Mail: General steps. Mail queued. not delivered. Configure Database Mail - SQL Server. Database Mail - test is OK. but jobs do not notify. Database Mail in SQL Server 2008 R2. Database Mail in SQL Server 2008. Database Mail in SQL Server 2012. Setup Database Mail in SQL Server 2008. Setting up Database Mail in SQL Server . Setup SQL Server Database Mail to use a Gmail. Hotmail. Yahoo

0 comments:

Post a Comment