Hi,

Is it possible to get an ansi attachement otherwise unicode ?

When I tried this code, I got an unicode textfile :

EXEC xp_sendmail @recipients = 'robertk',
@query = 'SELECT * FROM INFORMATION_SCHEMA.TABLES',
@subject = 'SQL Server Report',
@message = 'The contents of INFORMATION_SCHEMA.TABLES:',
@attach_results = 'TRUE', @width = 250

I need to get an ansi file. Does exist another technique ?

Thank.