File attachment or query results size exceeds allowable value of 1000000 bytes

DECLARE
    @tab char (1) = char (9)
EXEC msdb.dbo.sp_send_dbmail
    @profile_name = ' backupnotify ',
    @ Recipients = ' xxx@wuxiapptec.com ',
    @query = ' Select Cardno,badge,empname,empdep,swptime,macip  from CanteenProject.dbo.ADSSwipData where badge like ' t% ' and (Swptime>convert (varchar (7), DATEADD (Mm,-1,getdate ()), + ' -21 ' and swptime<convert (varchar (7), GETDATE (),) + ' -21 ') ',
    @subject = ' monthly trainees Checkin Log ',
    @attach_query_result_as_file = 1,
    @query_attachment_filename = ' traineescheckin-confidentialdata.csv ',
    @query_result_separator = @tab,
    @query_result_no_padding =1

Execute the above statement separately, the error:

File attachment or query results size exceeds allowable value of 1000000 bytes.

Solution:

Configure ' Database Mail ' to set the ' Maximum file size (bytes) ' Larger.