Solved

Appending attachment using sp_send_dbmail

Posted on 2008-06-25
1
854 Views
Last Modified: 2008-06-25
The email sends, but without the attachment.  Is there a problem with the code or does something need to be manipulated within the SQL Server settings?

msdb.dbo.sp_send_dbmail  @profile_name =  'Test' ,
@recipients = 'bill123453@yahoo.com',
@subject =  'Test' ,
@body =  'Test' ,
@query_attachment_filename =  'C:\Test.txt'
0
Comment
Question by:srejja
1 Comment
 
LVL 8

Accepted Solution

by:
sbagireddi earned 500 total points
ID: 21868578
Database Mail uses the Microsoft Windows security context of the current
user to control access to files. Therefore, users who are authenticated with
SQL Server Authentication cannot attach files using @file_attachments.

Are you authenticated as a SQL user.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question