reset sql server identity value

USE [DatabaseName]
Go

//First, delete all existing records
TRUNCATE TABLE [dbo].[TableName]
GO

//Now reset the identity column value
DBCC CHECKIDENT(‘[dbo].[TableName]’, RESEED, 0)
GO

Advertisements