I have a table named D&WContracts.
I can querry it by select * from "T&WContracts" ,I just put the whole table into double quote. It works for me.
But it did not work on one developer's machine. it conplained the special charactor '&'. We both have SQL server 2k client installed.
One solution I tried is that 'set quoted_quolifier on' on her machine. but it is not working. Acctually by default it already turned on.
I also tried reinstalled the sql2k client for her, It doesn't work.
Any other possible solution?
Thanks a lot.