We have the following proc that executes an e-mail and attaches the resulting query as a TXT attachment. Is there a way to make the attachment be a PDF?
@.MYRECIPIENTS varchar (500)
, @.MYSUBJECT varchar (50)
, @.MYBODY varchar (500)
, @.MYQUERY varchar (1000)
, @.MYIMPORTANCE varchar (10)
, @.MYPROFILE varchar (50)
as
declare @.NewSubject varchar(200)
set @.NewSubject = @.MYSUBJECT + ' ' + Cast(GetDate() as varchar(20))
Execute msdb.dbo.sp_send_dbmail
@.profile_name = @.MYPROFILE
,@.recipients = @.MYRECIPIENTS
,@.subject = @.NewSubject
,@.body = @.MYBODY
,@.query = @.MYQUERY
,@.importance = @.MYIMPORTANCE
,@.attach_query_result_as_file = 1
,@.body_format = 'HTML'
Jim,
That's not directly possible. As you recall, SQL Server isn't a printer client, and has no direct capabilities to interact with printers, and PDF is a printer format.
However, you may find some usefulness from a Google? search for a freely available stored procedure that is called "sql 2 pdf".
|||Thanks for the lead. I will follow up on it
No comments:
Post a Comment