db mail in Express2008

  • Does anyone know if database mail works in the SQLExpress2008 edition? My copy does not have the Wizard alot of the articles talk about, so I have been trying to use T-SQL scripts and the stored procedures to get it to work.

    I have spent two days trying to get it to work and cannot figure out how. Does this even work in this version?

    Thanks,

  • rdhigdon (10/9/2009)


    Does anyone know if database mail works in the SQLExpress2008 edition? My copy does not have the Wizard alot of the articles talk about, so I have been trying to use T-SQL scripts and the stored procedures to get it to work.

    I have spent two days trying to get it to work and cannot figure out how. Does this even work in this version?

    Thanks,

    I think it is one of features not supported in the Express edition.

    Kind regards,
    Gift Peddie

  • Review the documents here:

    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    Under the Enterprise Manageability section you will find whether or not Express supports Database Mail.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I was finally able to get it to work!!! yeahhhh

    The problem was my "good friend" ATT shutting off the SMTP ports (25)!!!. After I went in and created a quick C# program using System.Net.Mail I was able to debug and find the problem.

    There are several solutions: start your own email server, find a email provider that uses and doesn't block SMTP, or what I did was use my Microsoft "live.com" account.

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

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