March 16, 2010 at 5:16 pm
Hi people. It's a while since my last posting but you have been so helpful in the past.
I am developing an SQL Server database in full SQL2005, but which the client plans to run within SSE2005. This database is successfully attached within SSE and I have added many tables, Views, udfs and SPROCs to it quite successfully.
Now the client wants to run mass emailing via Database Mail from the app. I notice all the system SPROCs exist for it in the msdb database and sp_configure exists in the db I have been developing, but features such as SQL's "Surface Area Configuration Manager" (which can be used to turn on Database Mail) do not exist in the SSE version/interface.
Has anyone had a go at this? (I hope, I hope 🙂 🙂 )
It looks feasible to run Database Mail from within SSE once it is enabled on the client's Server, but I would appreciate knowing if anyone has tried it?
Thanks in advance. It is pretty important to my clients as they need this feature for the mass distribution of maintenance work requests.
Lester Vincent
Sydney
March 16, 2010 at 6:33 pm
As to my knowledge SSE2005 is not set up to use sp_send_dbmail by default. There are some important files missing.
However, there seems to be a solution where it's possible to still use it if there are some specific files from a non-Express version available "somehow".
And this "somehow" specifically makes me wondering if those "solutions" would be compliant with the SQL Express licence agreement. First step therefore would be to verify whether it's legal or not.
March 16, 2010 at 9:04 pm
I cannot see how use of Database Mail would be illegal, since it seems to contain exactly the same (Database Mail) system stored procedures as in SQL Server's Enterprise version 2005. What it doesn't have is the User Interface stuff (ie SQL Server Surface Area Configuration Configuration, the Database Mail Configuration Wizard), but it DOES have the System SPROC, sys.sp_configure (which can be found in any of the user-created databases, and by which Database Mail can allegedly be configured.
Searching in help, I found the following list of system SPROCs, all of which refer to Database Mail, and they all seem to be in the SSE version of the msdb database: -
sp.send_dbmail
sysmail_add_account_sp
sysmail_add_principalptofile_sp
sysmail_add_profile_sp
sysmail_add_profileaccount_sp
sysmail_configure_sp
sysmail_delete_account_sp
sysmail_delete_log_sp
sysmail_delete_mailitems_sp
sysmail_delete_principalprofile_sp
sysmail_delete_profile_sp
sysmail_delete_profileaccount_sp
sysmail_help_account_sp
sysmail_help_configure_sp
sysmail_help_principalprofile_sp
sysmail_help_profile_sp
sysmail_help_profileaccount_sp
sysmail_help_queue_sp
sysmail_help_status_sp
sysmail_start_sp
sysmail__stop_sp
sysmail_update_account_sp
sysmail_update_principalprofile_sp
sysmail_update_profile_sp
sysmail_update_profileaccount_sp
With all of that available in the SSE2005 version of the msdb database, how can it be illegal to use it, with due respect?
I would be delighted to hear from some good person who has dipped his/her toes in the water and is actually using Database Mail in SSE2005. Please???
Kind regards,
Lester Vincent
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply