Sql server identity update off

You need to move the data into another table and make the changes over there and insert the back the data into original table. Please mark as answer if this post helped you. The content you requested has been removed.

Ask a question. Quick access. Search related threads. Remove From My Forums. Salman A Salman A k 78 78 gold badges silver badges bronze badges. This method is the nicer way to go if you have foreign keys with cascading updates because you get the updates for "free". Ismail Hawayel Ismail Hawayel 1, 14 14 silver badges 14 14 bronze badges. If you want to reenumerate the values of an identity field, because for instance the values have gone mad, just do as follows: open table in design mode click on Identity Specification mark is identity as NO Your identity field is still a PK close and save design open table in edit mode Change the values of your Identity field as desired just be aware you cannot have duplicate values Close the table and open it again in design mode Replace your identity field is identity to Yes.

Close the table and you are done. Ramon Baiges Ramon Baiges 11 2 2 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

Sorry, it works perfectly well, I just didn't execute it as a SQL statement. Flip Oct 19, at PM 2 Comments. I'm still getting an insert error when I have turned the identity on. I added "GO" before and after my insert stmnts and it worked! Nov 8, at AM 1 Comments. Daniel Dec 9, at PM 1 Comments.

Masud Oct 17, at AM 1 Comments. Shahnawaz Mar 19, at AM 1 Comments. Thanks, Prashant. Learn more. Asked 8 years, 10 months ago. Active 2 years, 4 months ago. Viewed 83k times. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Vadim Tychonoff Vadim Tychonoff 4 4 silver badges 7 7 bronze badges. Community Bot 1 1 1 silver badge. Jon Egerton Jon Egerton Andomar Andomar k 44 44 gold badges silver badges bronze badges.