blog@six

...well, I’m running down the road tryin’ to loosen my load...

Posted 2 years ago

How to Reseed a SQL Server Identity Column

http://weblogs.asp.net/jeffwids/archive/2009/09/15/how-to-reseed-a-sql-server-identity-column.aspx

In SQL Server you can specify a column as an Identity column (ColumnName int IDENTITY(1,1) NOT NULL) to have SQL Server automatically set the value of this column upon insert by incrementing a seed…