January 23, 2009 at 12:57 pm
Hello, how do i send mail alerts over sql express edition?
January 24, 2009 at 7:35 pm
SQL Express holds all necessary stored procedures, service broker queues, etc... for proper mail handling.
However when you try to send an email the processing of queued mails fails with because an external process
called "DatabaseMail90.exe" couldn't be started.
This means that the file is simply missing.
By copying DatabaseMail90.exe, DatabaseMailEngine.dll and DatabaseMailProtocols.dll into the MSSQL\Binn directory
and executing system stored procedures in MSDB database called
dbo.sysmail_start_sp
dbo.sysmail_stop_sp
the queued mails are processed immediatly.
Now the only problem with this is that you have to get those 3 files from either standard or enterprise edition of SQL Server
but that is anoter matter 🙂
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply