Can I use the
DBCC CHECKIDENT(<table_name>, RESEED, value)
command to reset an identity column current value to the original one in SQL Server 2008?
If yes, is this the correct way of doing this operation without having any drawback? If not, is there an alternate way of doing this?
See Question&Answers more detail:os