WebThen open two instances of SQL Server Management Studio and from the first instance execute the spTransaction1 stored procedure and from the second instance execute the spTransaction2 stored procedure and you will notice that the deadlock error is handled by the catch block. This information is useful to determine if deadlocks are significantly affecting the performance of your application, and which objects are involved. Use the Lock:Deadlock Chain event class to monitor when deadlock conditions occur.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |