Home Forums SQL Server 2005 T-SQL (SS2K5) Is it Possible to renumber a Identity Column? RE: Is it Possible to renumber a Identity Column?
steveb.
SSC-Forever
Points: 46733
More actions
December 23, 2009 at 8:07 am
#1095940
you can use DBCC CHECKIDENT to change the Identity value
http://technet.microsoft.com/en-us/library/ms176057.aspx