Ashok Basnet

Engineer | Entrepreneur | Programmer | Blogger | CEO / Co-founder [Mantra Ideas Pvt. Ltd.]

Category

Database

Reset indentity value of Auto increment Key to 0 in SQL server 2008

I have been searching for resetting the Auto increment value of ID Column in MSSQL Server 2008 and finally solved the problem. You can simply do the following in SQL. The following line resets the Identity value for the ‘MyTable’… Continue Reading →

© 2017 Ashok Basnet

Powered by WordPressUp ↑