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
