Well, you CAN use SET IDENTITY_INSERT ON to create duplicates. Unless you have a unique constraint nothing prevents this from happening.