TSQL

This turns off the auto increment

SET IDENTITY_INSERT <table> OFF

This doesnt work. What you have to do is remove the Identity Specification for the column, but keep it the primary key. Then you can change the ids.

You might need to go to Tools > Options > Designers and uncheck "Prevent saving changes tht require table re-creation" to make the change.