Hi Grambow,

Thankyou for your reply. I followed the same steps except maintaining the Transaction in Stored procedure.

I got the solution now. I have done like this.

put the primary key on the column

Step1:...

Hi Julian,

Thank you for your suggession but I am not getting the Cat_id as identity column. I am explicitly passing the id and I need only one record in that...

Hi Veteran,

Thank you for your reply. More or less the stored procedure is excuting as expected. But, Here the problem occurs only when two requests were executing on the server...