Tuesday, September 7, 2010

How to reset identity seed value?

SELECT IDENT_CURRENT('TestTable') IdentityInTable -- shows current identity
Now execute the DBCC CHECKIDENT command to reset the Seed value for the table as
DBCC CHECKIDENT('TestTable', RESEED, 33)—reset identity
check the current Identity Value.
SELECT IDENT_CURRENT('TestTable') IdentityInTable

No comments:

Post a Comment