Msg 22051, Level 16, State 1, Line 0
File attachment or query results size exceeds allowable value of 1000000 bytes.
Hi fiernd, after 3 days illness now i am back in work and trying to short out some issues. Recently I got some error on Database mail, the error I face in SQL Server Database mail while sending bigger attachment using below query.
@body='An attachement has been included in this email.',
-- End T-SQL
I tried and issue resolved through below configuration. and now its working.
EXECUTE msdb.dbo.sysmail_configure_sp 'MaxFileSize', '2097152' ;
enjoy solving.... mean while.
Wishing you Happy Independence Day...