sql server - RESEED identity columns on the database

Question

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?

Answer 1

The value can be omitted. So if you use

DBCC CHECKIDENT (<table_name>, RESEED);

SQL Server sets the ident value to the correct next number - according to the numbers already in use. This is the only way to reseed identity values I know.