Monday, February 7, 2011

How to Reset the Identity Values?


You can set the identity values using 1. DBCC CHECKIDENT(TABLENAME,RESEED,0) 
                                                                  2. Truncate table.

No comments:

Post a Comment