ErcanOPAK.com

--View the current value:
DBCC CHECKIDENT ("{table name}", NORESEED)

--Set it to the max value plus one:
DBCC CHECKIDENT ("{table name}", RESEED)

--Set it to a spcefic value:
DBCC CHECKIDENT ("{table name}", RESEED, {New Seed Value})