Skip to main content
deleted 10 characters in body
Source Link
bp_
  • 421
  • 4
  • 6

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id

If it is a migration that would require you to look this info up, I'd suggest the absurdly simple DBA Tools: Copy db MailDBA Tools: Copy db Mail.

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id

If it is a migration that would require you to look this info up, I'd suggest the absurdly simple DBA Tools: Copy db Mail.

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id

If it is a migration that would require you to look this info up, I'd suggest the absurdly simple DBA Tools: Copy db Mail.

added 238 characters in body
Source Link
bp_
  • 421
  • 4
  • 6

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id

If it is a migration that would require you to look this info up, I'd suggest the absurdly simple DBA Tools: Copy db Mail.

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id

If it is a migration that would require you to look this info up, I'd suggest the absurdly simple DBA Tools: Copy db Mail.

Source Link
bp_
  • 421
  • 4
  • 6

You can also query this data with a select statement:

select *
from msdb.dbo.sysmail_profile p 
join msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id 
join msdb.dbo.sysmail_account a on pa.account_id = a.account_id 
join msdb.dbo.sysmail_server s on a.account_id = s.account_id