K모씨의 Story

use master

go

sp_configure 'show advanced options',1

go

reconfigure with override

go

sp_configure 'Database Mail XPs',1

--go

--sp_configure 'SQL Mail XPs',0

go

reconfigure

go

EXECUTE msdb.dbo.sysmail_add_account_sp

             @account_name = 'MailServiceAccount'

,            @description = 'DataBaser.Net Service Mail'

,            @email_address = 'admin@databaser.net'

,            @display_name = 'Databaser.Net'

,            @username='admin@databaser.net'

,            @password='패스워드'

,            @mailserver_name = 'mail.databaser.net'

EXECUTE msdb.dbo.sysmail_add_profile_sp

             @profile_name = 'MailServiceProfile'

,            @description = 'Profile used for database mail';

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp

             @profile_name = 'MailServiceProfile'

,            @account_name = 'MailServiceAccount'

,            @sequence_number = 1

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp

             @profile_name = 'MailServiceProfile'

,            @principal_name = 'public'

,            @is_default = 1 ;

/*

--참고: 지우기

EXECUTE msdb.dbo.sysmail_delete_profileaccount_sp

             @profile_name = 'MailServiceProfile'

,            @account_name = 'MailServiceAccount'

EXECUTE msdb.dbo.sysmail_delete_profile_sp

             @profile_name = 'MailServiceProfile' ;

EXECUTE msdb.dbo.sysmail_delete_account_sp

    @account_name = 'MailServiceAccount' ;

--exec msdb..sysmail_help_principalprofile_sp

EXECUTE msdb.dbo.sysmail_delete_principalprofile_sp

    @principal_name = 'guest',

    @profile_name = 'MailServiceProfile' ;

*/

--메일보내기

declare @body1 varchar(100)

set @body1 = 'Server :'+@@servername+ ' My First Database Email '

EXEC msdb.dbo.sp_send_dbmail

             @recipients='admin@databaser.net'

,            @subject = 'My Mail Test'

,            @body = @body1

,            @body_format = 'HTML' ;