Posted By

PalCoder on 06/14/13


Tagged

sql


Versions (?)

Reseting the seed of column identity in sql sever using stored procedures


 / Published in: SQL
 

using this code in a stored procedure you can reset the seed of the identity column in sql server database

  1. @seed int
  2. AS
  3. DBCC CHECKIDENT (Lease,RESEED,@seed)
  4. RETURN

Report this snippet  

You need to login to post a comment.