Home Forums SQL Server 7,2000 T-SQL Setting Identity Seed and Identity Increment RE: Setting Identity Seed and Identity Increment
sarmistead
SSCommitted
Points: 1671
More actions
July 21, 2003 at 5:42 pm
#466308
How about something like this as an example?
declare @hival int
select @hival = max(id) from mytable
dbcc checkident(mytable, reseed, @hival)
HTH,
Steve Armistead,
Database Administration
Panther Systems Northwest, Inc.
Vancouver, WA
Steve