Odd characters added to T-SQL Automatically

BabyGBear

I am using Reporting Services 2000 and therefore VS 2003 and am having a problem editing the T-SQL query in the data view of Visual Studio.

Basically if I manually edit the T-SQL query or touch anything in the designer view of the query I get odd characters added in the T-SQL and the query no longer works. I have tried re-installing VS2003 and RS 2000 but it's still happening.

FYI I also have SQLServer 2005 and VS 2005 on my machine as all applications we develop are in .Net 2.0 and 3.0. We only use VS2003 for RS.

Does anyone have a clue how to fix this Thanks

BabyGBear

the characters being added are highlighted below:

... tablename left outer join (select ...) aliasname

WITH „\ Ð×’ö͹ µÊ „\ Ð× „\ ø¶ Ð×Çf „\ „\ Ð× Ð× Í¹ Ð× µÊ „\  Äk

on tablename.column = aliasname.column ....

If I manually delete the highlighted section it puts it straight back in. I now can't edit any of our reports at all as its doing this to all of them. Help!