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