How to reset the identity

[devboycpp]

How can we reset the start of an identity column.

Best regards Hossein Yahoo ID :hosseinenick

[Pete OHanlon]

Use DBCC CHECKIDENT (tablename, RESEED, 9999). This would reset the next identity to 10000 on the table in question.

Deja View - the feeling that you've seen this post before.

[Mitesh Darji]

Use DatabaseName DBCC CHECKIDENT (tablename, RESEED, 0) OutPut : reset the column identity next value start to 1 :-O

Mitesh Darji