Post reply

Database mail

  • May 9, 2012 at 2:23 pm

    #256282

    How to verify Is Database Mail Turned On:(with query)

    Please help me

    Thanks!

  • May 9, 2012 at 2:35 pm

    #1485354

    This will tell you if Database Mail is enabled. It might not be configured however.

    sp_configure 'show advanced options', 1

    reconfigure

    GO

    sp_configure 'Database Mail XPs'

  • May 9, 2012 at 3:06 pm

    #1485366

    Thank You! 🙂

  • May 10, 2012 at 2:51 pm

    #1485989

    There is no need to turn on Advanced options:

    SELECT *

    FROM sys.configurations

    WHERE name = 'Database Mail XPs';

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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