Blog Detail

SQL SERVER: Configure Database Mail with SQL SERVER 2005
19 Nov 2009
Tejas Shah
/Project/ImageURL/1)mail11.jpg
We have used Database mail to send mail to client on each updates.This is a very simple process to configure. Let me share how to configure Database mail with SQL server 2005 with all of you. After setting up Profile and Account properly, you just need to write following code to send a mail to client:

Step 1:
 
Step 2:
 
Step 3:
 
Step 4: You might get this message:
 
Step 5: Create Profile
 
Step 6 : Create Account
 

That's it.
exec msdb.dbo.sp_send_dbmail 
@profile_name = 'ProfileName', IN our CASE, 'Tejas' 
@recipients = 'Client Email Address' , 
@blind_copy_recipients = 'BCC Address', 
@subject = 'Subject', 
@BODY = 'Message Body', 
@body_format = 'Message Type', it could be text OR html
Let me know if you have any complexity or comments in setting up Database mail.
 

Tags

SQLYoga Tejas Shah SQL Server Database Mail

About me

User

Tejas Shah

Microsoft Certified Professional Expert. I have 14+ years of experience in Design and Develop 100+ .Net applications using Asp.Net, C#, Asp.Net Core, VB.Net, SQL Server, MVC, AngularJS, JavaScript, Azure, HTML5 and CSS3.

Read More

Categories

Recent Post