Hi,

Please try this:

select top 10 id, Name, * from

syscolumns where

autoval is not null and

colstat=0

then

update syscolumns

set colstat=1

--select * from syscolumns

where id='id'

and name='Name'