Again one of the simple things, maby because I'm to leasy to remember of that I don't like to start profiler each time, or maby because you who did find this blog was just needing it.
SELECT [profile_id]
, [name]
, [description]
FROM
msdb.dbo.sysmail_profile
SELECT [a].[account_id]
, [a].[name]
, [a].[description]
, [a].[email_address]
, [a].[display_name]
, [a].[replyto_address]
, [s].[servertype]
, [s].[servername]
, [s].[port]
, [s].[username]
, [s].[use_default_credentials]
, [s].[enable_ssl]
FROM
msdb.dbo.sysmail_account a
INNER JOIN msdb.dbo.sysmail_server s
ON a.account_id = s.account_id
Hope you enjoy this blog! When you have comments, better solution and recommendation I like to hear from you. Dynamic Intelligence | LinkedIn | Blog | Twitter
Geen opmerkingen:
Een reactie posten