Reset IsIdentity of table to particular Value in SQL SERVER

 Syntax for setting to particular value is

 

DBCC CHECKIDENT ('table_name', RESEED, 100)  

-- Supply table name, here 100 is identity seed value

To Know the current seed value of the table use the below query

 DBCC CHECKIDENT ('table_name') -- Displays the current seed value