Showing posts with label autmatic. Show all posts
Showing posts with label autmatic. Show all posts

Wednesday, March 21, 2012

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