how to avoid transaction deadlock occur due to stored proc.?

May 17 2013 4:33 AM

hello,
Actually I have one stored procedure containing all delete statements...
I got an error of transaction deadlock in some cases....
not everytime...
So plzz help me to avoid this issue...

Ratika Tamboli