Search:

Thanks, figure it out



alter table Scrapbinweights alter constraint(RecID autoinc nextvalue 41 step 1)

Is there a way reset the auto-increment value for an autoinc field?

like:


delete from JobCost
go

DBCC CHECKIDENT('JobCost', reseed, 0)
go