In my current project we have been inserting quite a few records into the data base, we dint chk abt implementing locks,
my client doesnt want any duplicate records for a column in a table, there is no primary key constraint on any of the column for the table on which we are inserting datas into.
though this problem arises only when different users try to insert values at the same time.
we use SP's for inserting,

let me know a simpler way to implement this.

Any help appreciated.