Oct
20
2012

How To Reset Auto-Increment in MS SQL Server

After deleting all the entries in the table. The increment will not reset by it self. To reset the auto-Increment to 1, use the SQL Query below: DBCC CHECKIDENT ([Table Name], RESEED, 1)

Calendar

<<  April 2020  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar