Reset Automatic Numbering

Does anyone know how to reset the autmatic numbering in SQL?DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
Thanks ,
P.C Sekhar.
"Comm Port not Working" <CommPortnotWorking@.discussions.microsoft.com> wrote
in message news:79520BCF-F4A6-4038-B817-551F70EB269E@.microsoft.com...
> Does anyone know how to reset the autmatic numbering in SQL?|||That worked ...Thank you!!!
"P.C Sekhar" wrote:

> DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
> Thanks ,
> P.C Sekhar.
> "Comm Port not Working" <CommPortnotWorking@.discussions.microsoft.com> wro
te
> in message news:79520BCF-F4A6-4038-B817-551F70EB269E@.microsoft.com...
>
>sql