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

Revision: 63891

at June 14, 2013 23:55 by PalCoder

Initial Code

@seed int
AS
	DBCC CHECKIDENT (Lease,RESEED,@seed)
	RETURN

Initial URL

Initial Description

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

Initial Title

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

Initial Tags

sql

Initial Language

SQL