In table tUSERI primary key was added in the column [Email].
I deleted a user email@example.com from tUSER.
When I try to add the same user firstname.lastname@example.org got the following error.
What causes the error?
Please help clean and update the table tUSER.
Violation of PRIMARY KEY constraint 'PK_tuser_2'. Cannot insert duplicate key in object 'dbo.tuser'. The duplicate key value is (email@example.com)