This worked for the System error 604 that I was getting in SQL Server 2000

select top 10 id, Name, * from

syscolumns where

autoval is not null and

colstat=0

then

update syscolumns

set...