Post reply

Database Mail in SQL Sever 2005 Express

  • August 26, 2009 at 4:29 pm

    #225425

    Hi,

    I've seen some posts in this forum mentioning Database Mail and SQL Server 2005 Express in the same sentence. My instance of SQL Server 2005 Express doesn't have a "folder" for Database Mail under the "Management" folder. Is this an add-on?

    Thanks!

    Riz

    Riz

  • September 1, 2009 at 9:53 am

    #1047632

    I've been looking into this as well and unfortunately this was not inluded in the Express edition, you will need to upgrade to full SQL i'm afraid.

    The way i got round it was to have everything i needed written into triggers / stored procedures and then added a VB Script as a scheduled task that sent the emails out..

    Hope it helps..

    Sam Marsden

  • September 1, 2009 at 9:54 am

    #1047634

    I've been looking into this as well and unfortunately this was not inluded in the Express edition, you will need to upgrade to full SQL i'm afraid.

    The way i got round it was to have everything i needed written into triggers / stored procedures and then added a VB Script as a scheduled task that sent the emails out..

    Hope it helps..

    Sam Marsden

  • September 1, 2009 at 10:21 am

    #1047659

    Thanks very much for the tip Sam. 🙂

    Riz

  • September 2, 2009 at 7:13 pm

    #1048505

    There's always this old chestnut:

    http://www.sqldev.net/xp/xpsmtp.htm

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

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