| How to
reseed the identity value on a table? |
|
One way of doing
it is using dbcc:
DBCC CHECKIDENT (TableX, RESEED, 30)
Second way: turn
identity insert off, do an insert with the new seed, turn identity
insert on.
|
| Best in the World
in SQL Server Training |
|