problem in changing my primary key column seeding

Question

i need a script to change my identity column seeding just from 3000 to 5000

Answer 1

SQLServer

DBCC CHECKIDENT ('TableName', RESEED, 5000)

http://msdn.microsoft.com/en-us/library/ms176057.aspx