The original source from http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx
The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.
DBCC CHECKIDENT('Customer', RESEED, 0)
Search Here
MyLot Discussion
Wednesday, March 10, 2010
Reset Identity Column in SQL SERVER
Label: SQL Server 2005
Subscribe to:
Post Comments (Atom)
0 Comments:
Post a Comment