Click here to Skip to main content
14,579,188 members
Rate this:
Please Sign up or sign in to vote.
HI Team,

I am facing deadlock issue in the SQL Server. I have two process using the same table at same time. first process will insert the records using bulk insert and second process will update the records in the same table.

Please could you let me know how can avoid deadlock.

What I have tried:

I found Bulk insert will create tab lock on the table.
Posted
Updated 29-Jun-20 22:23pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You already posted this question in the Database forum. Please do not crosspost.
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100