snippetsqlCritical
How can I see the current Database Mail configuration?
Viewed 0 times
cantheseedatabasemailcurrenthowconfiguration
Problem
Our SQL Server (2008) instance is configured to send mail and everything is working correctly, but I can't figure out how to view the existing configuration, in particular the SMTP server.
From SSMS I can only start the configuration wizard, and I can't find anything online - plenty of info on how to set it up but nothing on how to view the current settings.
How can I view the existing settings?
From SSMS I can only start the configuration wizard, and I can't find anything online - plenty of info on how to set it up but nothing on how to view the current settings.
How can I view the existing settings?
Solution
+1 to @jsauni for the wizard
You can also use the following system functions.
The wizard is probably easier to follow but these will give you everything at once without having to go back and forth through the wizard. I find it a bit cumbersome. :)
You can also use the following system functions.
EXEC msdb.dbo.sysmail_help_configure_sp;
EXEC msdb.dbo.sysmail_help_account_sp;
EXEC msdb.dbo.sysmail_help_profile_sp;
EXEC msdb.dbo.sysmail_help_profileaccount_sp;
EXEC msdb.dbo.sysmail_help_principalprofile_sp;The wizard is probably easier to follow but these will give you everything at once without having to go back and forth through the wizard. I find it a bit cumbersome. :)
Code Snippets
EXEC msdb.dbo.sysmail_help_configure_sp;
EXEC msdb.dbo.sysmail_help_account_sp;
EXEC msdb.dbo.sysmail_help_profile_sp;
EXEC msdb.dbo.sysmail_help_profileaccount_sp;
EXEC msdb.dbo.sysmail_help_principalprofile_sp;Context
StackExchange Database Administrators Q#47058, answer score: 70
Revisions (0)
No revisions yet.