I am trying to send the results of a stored procedure as a csv file. I can get everything to work EXCEPT the file is being sent it UNICODE. How do I send a file in ASCII?
exec master.dbo.xp_sendmail @recipients = 'youngp'
, @query = 'ap_GetLiborRates @LastObsDate = ''02-MAy-2003'''
, @attachments = 'Rates.csv'
, @subject = 'Libor Rates'
, @attach_results = 'True'
, @separator = ','
, @width = 1000
, @dbuse = 'Development'
(Knowledge is power! Get some!)