Advanced Search

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

/ Published in: SQL
Save to your folder(s)
using this code in a stored procedure you can reset the seed of the identity column in sql server database

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. @seed INT
  2. AS
  3. 	DBCC CHECKIDENT (Lease,RESEED,@seed)
  4. 	RETURN

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.