Occasionally, I need to reset the value of the identity column in MS SQL database. I keep forgetting how to do this, and have to search all the time.

So here is a note to myself:

DBCC CHECKIDENT (TableName, RESEED, 0)