How do I check the current identity column seed value of a table and set it to a specific value?


View the current value:

Set it to the max value plus one:
DBCC CHECKIDENT ("{table name}", RESEED)

Set it to a spcefic value:
DBCC CHECKIDENT ("{table name}", RESEED, {New Seed Value})

Note for Synced Sites:
In a BirdDog snychronized enviornment it is critical that the seed values be set to the correct value. Do not reset the seed value without discussing with BirdDog Support.

To reset the identity seed value you will have to know the seed range. To determine the appropirate seed value run the following query:

select MAX({identity column name}) + 1
from {table name}
where {identity column name} < {maximum value of this sites range}