Sending Emails From SQL Server 2012 Stored Procedures

sql-server stored-procedures sql-server-2012 database-mail
Paul Brown picture Paul Brown · Jan 4, 2013 · Viewed 9.1k times · Source

We require the ability to sent emails from stored procedures (SQL Server 2012) via SMTP.

We need to retain control over the emails "FROM" address and "Display Name" so this I believe rules out Database Mail as these are hard set in the created profiles (would be great to over ride tho! Anyone know how?)

What other options are available to us?

Thanks Paul

UPDATE: Would it be stupid to, in code, create the required temporary Database Mail profile, use it to send the required email once, and then delete the profile?

Answer

Alex K. picture Alex K. · Jan 4, 2013

From 2008 onwards you can create a basic profile and then override the details with @from_address/reply_to;

EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'my profile',
    ...
    @subject = 'The Spice must flow',
    @from_address = '"Bob Smith" <[email protected]>',
    @reply_to = '[email protected]'

Related questions

SQL Server IF EXISTS THEN 1 ELSE 2

Using Sql Server 2012. I have a stored procedure and part of it checks if a username is in a table. If it is, return a 1, if not, return a 2. This is my code: IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName =…

Read More
Stored procedure EXEC vs sp_executesql difference?

I've written two stored procedure one with sp_executesql and other doesn't have sp_executesql both are executing properly same results, I didn't get what is the difference here between EXEC (@SQL) vs EXEC sp_executesql @SQL, N'@eStatus varchar(12)…

Read More
Unable to Modify User-Defined Table Type

I have a SQL User-Defined Table Type. It used in many stored procedures.Now i need to change a column in that table type. I tried to drop and recreate the User-Defined Table Type.But SQL Server doesn't Allow that. …

Read More