Edit Table - Update Identity Initial Value to Max(Col) + Increment
When editing a table with a column that has an Identity specification, set the initial value to the max value of the existing data in the identity column plus the increment so that PK Constraints aren't triggered on subsequent insert. Possibly prompt to perform this?
1
vote
Paul
shared this idea