Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to set file attachment limit sysmail_configure

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-03-17 : 14:13:22
How to increase the database mail file attachment limit using the following SP:
sysmail_configure_sp

It seems like it is set to 1MB.
Thank you very much for the helpful info.

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-03-17 : 14:29:05
I got it:
EXECUTE msdb.dbo.sysmail_configure_sp
'MaxFileSize', '10485760' ;

Thank you all.


quote:
Originally posted by cplusplus

How to increase the database mail file attachment limit using the following SP:
sysmail_configure_sp

It seems like it is set to 1MB.
Thank you very much for the helpful info.


Go to Top of Page
   

- Advertisement -