Hi All, I am facing deadlock situation as shown in below snap:
What I see is it is a stored procedure called from Delphi application. In that stored procedure either Insert or Update statements are executed based upon the flag. My question is, if I put transaction inside Delphi application of this stored procedure call, will it put respective table(s) also in transaction? or do I need to follow any other approach? Thanks In Advance. With Best Regards. Vishal [Non-text portions of this message have been removed]