Can you edit a field with Identity Specification active?
Posted on 2009-04-01
If you have a field in a table with the identity specification set as "yes"...is there a way to edit that field in the tables? For example purposes only, MyTable has a field named MyID with identity spec set to yes to start at 20090001 in increments of 1. So one of the records in this table has a MyID of 20090010, but I want to change this MyID to 20080500. Is there a way to do this, without writing the script to change the identity spec to no, make the change, and then run the script to set the identify spec back to yes?