How to Increase the Maximum allowed Attachment File Size for email using sp_send_dbmail

Solution:

[Method 1]

(Within SQL Server Management Studio)
Management -> Database Mail -> Configure Database Mail
-> Next -> View or change system parameters -> Maximum File Size (Bytes) : 1000000 => 5000000

[Method 2]
exec msdb.dbo.sysmail_configure_sp 'MaxFileSize','5000000';

 

arrow
arrow
    全站熱搜

    DanBrother 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄