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]