vincephuah

i try doing it in sql management studio and it still complain same error - primary key violation.

What do you mean？If you do this in SQL Management Studio and it still fails……