database mail

• sql_prodigy

  SSCrazy

  Points: 2254

  More actions

  July 2, 2009 at 7:51 am

  #207853

  hi everyone,

  anyone have a query that selects and returns the default mail profile for a sql server?

  thanks

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 2, 2009 at 8:03 am

  #1019168

  SELECT * FROM msdb.dbo.sysmail_principalprofile

  There is a column IsDefault..

  You can get a list of profiles with sysmail_help_profile_sp.

  CEWII