Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to detect whether Database mail is enabled or not Expand / Collapse
Author
Message
Posted Monday, November 17, 2008 3:50 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:07 PM
Points: 1,688, Visits: 8,760
Hi,

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

MJ
Post #603998
Posted Monday, November 17, 2008 4:17 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, April 12, 2013 12:23 PM
Points: 606, Visits: 587
Try this:

EXECUTE msdb.dbo.sysmail_help_status_sp ;

Hope this helps.
Post #604014
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse