Here is the text of the stored procedure:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

/* THIS IS A GENERAL SEND MAIL STORED PROCEDURE

Written by Ron West (ronw@ronwest99.com)

Dynamically creates accounts and...

Here's the security setup that's required:

--create the role in msdb

USE [msdb]

GO

/****** Object:  DatabaseRole [CanSendEmail]    Script Date: 11/03/2005 09:31:08 ******/

CREATE ROLE [CanSendEmail] AUTHORIZATION [dbo]

grant select on sysmail_account to CanSendEmail

grant select on...

There was one thing missing in the implementation of 2005 database mail: Dynamic Profiles.

The company I work for sends lots of email on behalf of our reseller customers (impersonating them).

It took a...