Step towards SharePoint

 DBCC CHECKIDENT ('TableName', RESEED, 1000);