Here is the exception I am getting, any idea why this might be happening:
Exception: ThisMethod is done: let this go: Exception:
Transaction (Process ID 74) was deadlocked on lock |
communication buffer resources with another process and has been chosen as the deadlock victim.
Rerun the transaction. Stack Trace: at
This previous thread on the deadlock topic, along with the links it contains, might help you: Deadlock|||Thanks for the reply.
While users are working in the user interface I am inserting data to the table with another that is back end for the user interface. Although we do insert and update I do not think that user are dealing with the same data row, so I am assuming I should not be receiving deadlock. Does SQL server do RowLock or TableLock. How can I get my insert and update work on the RowLock. Can you give me sample sql statement.
No comments:
Post a Comment