SQL Server發送Mail (2005+)

只支援SQL2005以後版本

EXEC msdb.dbo.sp_send_dbmail @recipients='sheauren@gmail.com',
    @subject = 'SUBJECT',
    @body = @HtmlBody,
    @body_format = 'HTML',
    @profile_name='DefaultSMTPMail'; 
-- DefaultSMTPMail需要先定義好,發送信件依賴此設定.

附件大小調整至5M

EXECUTE msdb.dbo.sysmail_configure_sp 'MaxFileSize', '5242880'