Duncan,

Thanks for the reply. I upgraded my instance then removed 05. I did test it on two other areas before going all in but I did find the problem.

I use...

Seems like a lot just for an email to find out who is deleting my report programmers subscriptions. Do you have a query that I can use? I get what...

@ Minaz and Ali - Thanks I got installed. The problem was the instance would not restart completly. We had to shut down and power the instance back on in...

Thanks Guys. I used the removal tool. The issue was that the instance was not completely rebooting and as a result not removing the services. After running the removal tool...

When running this job it stops writing to excel where I have;

Replace(Rtrim(Ltrim(Replace(replace(dbo.MyTable.MyColumn, Char(13),''),Char(10),''))),',','') AS 'Column4', ---this one exports

After this line it will not export the rest of the query, if...

SELECT DISTINCT

dbo.MyTable.MyColumn AS 'Column1',

RTRIM(dbo.MyTable.MyColumn ) AS 'Column2',

RTRIM(dbo.MyTable.MyColumn ) AS Column3',

Replace(Rtrim(Ltrim(Replace(replace(dbo.MyTable.MyColumn , Char(13),''),Char(10),''))),',','') AS 'Column4',

--REPLACE(RTRIM(dbo.MyTable.MyColumn ), Char(13)+ Char(10),'') AS 'Column4',

RTRIM(dbo.MyTable.MyColumn ) AS 'Column5',

RTRIM(dbo.MyTable.MyColumn ) AS 'Column6',

dbo.MyTable.MyColumn AS...

SELECTDISTINCT

dbo.MyTable.MyColumn AS 'Column1',

RTRIM(dbo.MyTable.MyColumn ) AS 'Column2',

RTRIM(dbo.MyTable.MyColumn ) AS Column3',

Replace(Rtrim(Ltrim(Replace(replace(dbo.MyTable.MyColumn , Char(13),''),Char(10),''))),',','') AS 'Column4',

--REPLACE(RTRIM(dbo.MyTable.MyColumn ), Char(13)+ Char(10),'')...

Just so I am clear this is to get it to export from Excel 2003 to 2007?