Before answering

What is the primary key of your table?

Is that user defined... or generated by any user defined function?

If So,

You may have to use the locking method.

Else

Try to set the primary key of your table with identity Insert - Yes

So it will automatically increment per insert..