jared-709193 (9/21/2011)

---

Hmm... What I would do is create another column and make it an identity insert starting at 10000 or something... You could even make this your primary key and...

GSquared (9/21/2011)

---

sjusko (9/21/2011)

---

GSquared (9/21/2011)

---

Will other tables reference the ID column in this table? If so, updating it will break those references.

What you're probably better off doing is, if the...

GSquared (9/21/2011)

---

Will other tables reference the ID column in this table? If so, updating it will break those references.

What you're probably better off doing is, if the Part Number...

jared-709193 (9/21/2011)

---

I think we really need more information here... What exactly are you trying to do; i.e. if a new row is inserted, what changes with an old row? Also,...