How to detect whether Database mail is enabled or not

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  November 17, 2008 at 3:50 pm

  #383409

  Hi,

  How we can detect whether Database mail is enabled or not using tsql commands rather than checking it under surface area configuration?

  MJ

• sqlizer

  SSCrazy

  Points: 2120

  More actions

  November 17, 2008 at 4:17 pm

  #899614

  Try this:

  EXECUTE msdb.dbo.sysmail_help_status_sp ;

  Hope this helps.