Sergey,
BOL says the same things as Allen said but it doesn't work. I still get the same message about ad hoc updates.
Another idea anybody?
Since everybody wants to know my reason : In SQL7 there was a column called suid in sysusers. This column was removed in SQL2000. My problem is I have an application (without source code ) which gives me an error because it doesn't find this column. When I say ignore, it work just fine but I want to get rid of the error. The syntax they use is "select name from sysusers where suid in (select suid form master.sysusers where bla bla bla). If I had source code I could change it to another column name but I don't.
Diane Robitaille
Diane Robitaille eng.