Send Email using SQL 2008 expression

Question

Send Email using SQL 2008 expression

DIB IN

Right there with Babe

Points: 749
More actions
May 25, 2011 at 5:26 am

#250794

Is it possible to send email using SQL 2008 express edition from database?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

calvo SSChampion Points: 12930 More actions · Answer 1

No. You can only send emails from Workgroup, Web, Standard, Enterprise, and Datacenter.

______________________________________________________________________________________________
Forum posting etiquette.[/url] Get your answers faster.

SeanAchim Right there with Babe Points: 764 More actions · Answer 2

Yep, the Database mail functionality in SQL Server Express is disabled.

The solution is to develop a simple SMTP app and use this within SQL Server as a CLR. Take a look at this blog that gives a very good overview of how this can be done:

Secondly, that fact that the feature is disabled is a technical issue that can be hacked/tweaked/massaged to make it work for you. There is quite a long discussion about doing exactly that over here:

The problem with this approach, other than the obvious issue of copying files from a "paid for version" to the express edition, is that fact that whenever an update is applied you will need to revisit the installation process - as one of the people in this discussion had done. The point is that it can be done and doing it helps to grow your understanding of the inner workings of the system.

My money lies in the CLR component though.

DIB IN Right there with Babe Points: 749 More actions · Answer 3

Thanks for your reply for CLR integration which is working fine for me.

Thanks Again.

Regards