SQL Server 2012 Express: Setup Database Mail (sp_send_dbmail)

Guys good news!
SQL Server 2012 Express still supports Database Mail (DB Mail), but it’s well hidden 🙂

The fully licensed editions of SQL Server 2012 do have an easy setup wizard, but (like in SQL Server 2008) the needed components (service, tables and stored procedures) are still present in the Express-edition!

The tables are programmatically set to ‘hidden‘, because I can still query them by using:

select * from msdb.dbo.sysmail_account

The Stored Procedures (SP’s) are visible though:

How to get things working?
Follow the steps in the blogpost (was originally documented for SQL Server 2005, but still applies to the 2012 Editions of SQL Server).

You may skip step 7:
Click here!





Advertisements

3 thoughts on “SQL Server 2012 Express: Setup Database Mail (sp_send_dbmail)

  1. Pingback: How To: Send e-mails from your Windows Azure Virtual Machine (VM) to Office 365 (Exchange) | Clint Huijbers's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s