Post reply

Database mail

  • December 22, 2008 at 5:02 am

    #127626

    Hi

    How to enable Database Mail feature first time in SqlServer 2005.

    can any body help me....

  • December 22, 2008 at 6:49 am

    #916117

    sowju.j (12/22/2008)

    Hi

    How to enable Database Mail feature first time in SqlServer 2005.

    can any body help me....

    If you simply want to enable it use the Surface Area Configuration tool. If you wan tto use Database Mail you have to configure it. Therefore in SSMS right-click on Dtabase mail and select "Configure Database Mail".

    And maybe try reading Books Online, you should have found this information within seconds.

    [font="Verdana"]Markus Bohse[/font]

  • December 22, 2008 at 7:12 am

    #916133

    SP_CONFIGURE 'Database Mail XPs',1

    GO

    RECONFIGURE

    GO

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • December 23, 2008 at 8:01 am

    #916767

    If you want to use DBMail for alerts, be sure to enable this in the SQL Server Agent properties.

    David

  • December 23, 2008 at 1:39 pm

    #917073

    hi,

    Sql server surface configuration ---> surface area configuration for features --->select Database mail ---> enable database mail store procedures

    This will enable database mail.

    Enjoy u r Christmas Holidays 🙂

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

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

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