This is exactly why MS warns against accessing system tables directly.
According to the BOL, the old suid column is now the syslogins.sid column. Lookup SUID in the index.
>> If I had source code I could change it to another column name but I don't.
Can you get hold of the source? Is the vendor still around? I'm guessing that this is a query that is embedded in the code right? Score another one for the user of stored procedures ;-)
Don't shoot the messenger but you may have to go back to SQL Server 7.0.
-Mike
>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