I have a web application build with asp.net(c#) and SQL Server 2005. Where user can enter customer record. But my problem is that, whenever end user try to enter record from two different places at the same time, it shows an error for violation of primary key constrain. How can I solve this? Both the end user are from different location and should be able to enter record at the same time. Any solution? Please help me out.