Tuesday, November 27, 2007

To reset sql db identity

DBCC CHECKIDENT (TableName, RESEED, RESEEDVALUE)

eg:
DBCC CHECKIDENT (dbo.TableName, RESEED, 0)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)