Problem With Quoted Identifier On 2000 Sql Server

Hi,

If you run the following code on 7.0 server, it will send a test file in csv format.

--*********************************
create table ##temp1
(tmp varchar(15))

insert into ##temp1
select 'Erin, Brockowich'

declare @cmd varchar(255)

select @cmd = 'select * from ##temp1'

EXEC master..xp_sendmail
@recipients = '<email>', --change to your email
@query = @cmd,
@subject = 'test-test',
@attach_results = 'true',
@attachments = 'test.csv',
@width = 800

drop table ##temp1
--**********************************

When you receive an email and double click on te attachment, it will launch excel automatically and put 'Erin' and 'Brockowich' in seperate columns. which is good and that is the way I want it.

But if I run this code on sql 2000 server, it will generate a file with 'csv' extension unrecognizable by excel. If you open this 2000 attachment in notepad, you can see that the data looks like
"Erin, Brockowich" (vs Erin, Brockowich without quotes on 7.0 server ), no wonder it is unrecognizable by excel.

I have set quoted_identifier off while compiling all the user sps on 2000 server. But while sending emails from within the procedure, all the attachments still generated with quotes.

How can I get rid of the quotes? We have at least 45 routines running generating coma seperated files as a result of the query and sending emails to the clients for years. Now all of a sudden all the routines got messed up with 2000 upgrade.

Can you suggest any work around?

Thanks,
Shaili
:confused: