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 Let me know if you have any complexity or comments in setting up Database mail.
@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
Learn SQL and database management at SQLYoga for articles, tutorials, and tips to improve your skills and streamline data operations. Join our community!
November 3, 2009
SQL SERVER: Configure Database Mail with SQL SERVER 2005
Labels:
Database Mail,
SQL Server,
SQL Yoga,
Tejas Shah

Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment