Have you ever wondered how to reset the auto increment in SQL table? Well I did, and here is how to achive this:
DBCC CHECKIDENT('test', RESEED, 0)
where 'test' is the tables name we want to reset. If you already have some date into your table your next inserting will start from 0.
Best regards,
Stoyan Bukovich
Executive manager
SNB Solutions
Cell.: +52 6241 616969
E-mail:
s.bucovich@snb-bg.comWeb:
www.snb-bg.com