Mail alerts

  • Hello, how do i send mail alerts over sql express edition?

  • 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