Get DBMail information

,

just copy the code and run it...

CREATE TABLE #temp01
 (
 profile_id INT,
 [name] VARCHAR(50),
 description VARCHAR(50)
 )
INSERT INTO #temp01
 EXECUTE msdb.dbo.sysmail_help_profile_sp ;
CREATE TABLE #temp02
 (
 profile_id INT,
 profile_name VARCHAR(50),
 account_id INT,
 account_name VARCHAR(50),
 seq int
 )
INSERT INTO #temp02
 EXECUTE msdb.dbo.sysmail_help_profileaccount_sp ;
CREATE TABLE #temp03
 (
 account_id INT,
 [name] VARCHAR(50),
 description VARCHAR(50),
 email_address VARCHAR(50),
 display_name VARCHAR(50),
 replyto_address VARCHAR(50),
 servertype VARCHAR(50),
 servername VARCHAR(50),
 port INT,
 username VARCHAR(50),
 use_default_credentials VARCHAR(50),
 enable_ssl int
 )
INSERT INTO #temp03
 EXECUTE msdb.dbo.sysmail_help_account_sp ;
SELECT a.name,
 b.account_name,
 c.description,
 c.email_address,
 c.display_name,
 c.replyto_address,
 c.servertype,
 c.servername,
 c.port,
 c.username,
 c.use_default_credentials,
 c.enable_ssl
FROM [#temp01] AS a
 INNER JOIN [#temp02] AS b ON a.profile_id = b.[profile_id]
 INNER JOIN [#temp03] AS c ON b.account_id = c.account_id
DROP TABLE #temp01
DROP TABLE #temp02
DROP TABLE [#temp03]

Rate

4.75 (4)

Share

Share

Rate

4.75 (4)