Creating New Account :EXECUTE @rv=msdb.dbo.sysmail_add_account_sp
@account_name =
,
@description=,
@email_address = ,
@replyto_address=,
@display_name = ,
@mailserver_name = ,
@port=,
@username=,
@password=;
GO
Example :
EXECUTE @rv=msdb.dbo.sysmail_add_account_sp
@account_name = 'SampleAccount',
@description='Creating Sample Email Account in Database Mail',
@email_address = 'mail@yourdomain.com',
@replyto_address='reply@yourdomain.com',
@display_name = 'Database Account',
@mailserver_name = 'smtp.yourdomain.com',
@port=25,
@username='mail@yourdomain.com',
@password='EmailPassword';
GO
To View Account :
select * from msdb.dbo.sysmail_account