InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 07:57:00 GMT20http://www.sqlservercentral.com/Forums/Topic1359854-391-1.aspxThe script above does indeed work -- the email just went to the junk folder :-DTue, 19 Feb 2013 11:35:57 GMTsierra4http://www.sqlservercentral.com/Forums/Topic1359854-391-1.aspxThe query looks good. I don't think there is any additional arguments to be passed for attachements. The only thing I would like to point out is SQL Server limits the size of attachment to 1 MB by default.Mon, 17 Sep 2012 09:53:35 GMTmbhandarihttp://www.sqlservercentral.com/Forums/Topic1359854-391-1.aspxhi,below is the script i have in SQL Server Agent.SET ROWCOUNT 0 EXEC msdb..sp_send_dbmail @profile_name = 'SQL Mail',@recipients = '<me@email.com>',@subject = 'subject',@body = 'Please see attached report',@file_attachments = 'D:\MSSQL10.MSSQLSERVER\MSSQL\Log\output_report_3.txt'--@query = 'sp_helpdb userdb',--@execute_query_database = 'MSDB',--@query_result_separator = ',',gothe job completes successfully but does not send an email. there are no errors generated.when i comment out @file_attachments, and instead uncomment the @query parameters then i do receive an emailwhat am i missing with the @file_attachments parameter?thank youSat, 15 Sep 2012 16:30:34 GMTsierra4