reset Identity

I have an integer field set identity ON. How can I reset the identity number
to 1? Thanks Anyway!
You need to use the DBCC CHECKIDENT command. DBCC CHECKIDENT(TableName,
RESEED, IdentityValue)
ie. To reseed the Identity of the Employees table to 0:
DBCC CHECKIDENT(employees, RESEED, 0)
- Peter Ward
WARDY IT Solutions
"kinloan" wrote:

> I have an integer field set identity ON. How can I reset the identity number
> to 1? Thanks Anyway!
>