Sending E-Mail through SQL Server stored procedures

On 12 Apr, 2015

MS SQL DBA

By : Charith Silva

No Comments

Basic emails can be sent using below user-defined stored procedure. Before you use this stored procedure you have to create a profile and account using the Configure Database Mail Wizard which can be accessed from the Configure Database Mail menu of the Database Mail in Management section in SQL Server instance.

USE [Master];
GO

CREATE PROCEDURE [dbo].[SendEmailNotification]
 @To nvarchar(4000),
 @Subject nvarchar(4000),
 @Body nvarchar(4000),
 @Attachment nvarchar(4000) = " "
AS

EXECUTE msdb.dbo.sp_send_dbmail
 @Recipients = @To,
 @Subject = @Subject,
 @Body = @Body,
 @File_Attachments = @Attachment

USE [Master];

CREATE PROCEDURE [dbo].[SendEmailNotification]

@To nvarchar(4000),

@Subject nvarchar(4000),

@Body nvarchar(4000),

@Attachment nvarchar(4000) = " "

EXECUTE msdb.dbo.sp_send_dbmail

@Recipients = @To,

@Subject = @Subject,

@Body = @Body,

@File_Attachments = @Attachment

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva