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!





HowTo: Setup SQL Server Linked Server to MySQL

This week I had to create a linked server to a MySQL database on SQL Express (development environment)….whoohooo!…NOT
But ok, it’s possible. Found this step-by-step blogpost.

Start by downloading the MySQL Connector/ODBC.
(You need to register first…)

The funny thing is, I had to enter a full provider string (instead of what the blog mentioned):

Driver={MySQL ODBC 5.1 driver};Server=;Port=3306;Database=;Uid=;Pwd=

(Port is optional and default btw)

The result:

Conclusion: It’s easy once you’ve done it before 🙂
@webhosting companies: Want reports or a PowerPivot on that thing?
Send me a mail! @BumbleBI (Dutch)