EXEC msdb..sysmail_update_account_sp @account_name = 'SMTP_database_mail', -- sysname
@email_address = N'altersemail@example.com', -- nvarchar(128)
@display_name = N'Database Mail', -- nvarchar(128)
@replyto_address = N'altersemail@example.com', -- nvarchar(128)
@description = N'Primary database alerts profile', -- nvarchar(256)
@mailserver_name = 'smtp.office365.com', -- sysname
@port = 587, -- int
@username = 'altersemail@example.com', -- sysname
@password = 'SecurePassword', -- sysname
@use_default_credentials = 0, -- bit
@enable_ssl = 1
Like this:
Like Loading...
Related