Need to understand concepts about locking and blocking.
Could you please provide some insight on the locking and blocking i.e.
1. How to figure out the SQL text of spid which comes as an output of “sp_who”
2. How to check which table is locked and by which sp id
3. Suppose my procedure takes 2 min. everyday and suddenly one day it took 2 hrs. to complete. So what could have been occoured, how to check whether table used by procedure were locked or not, if yes then which spid was responsible for table locking and etc etc.
Many ThanksCheck the Sybase Wiki @ sybasewiki.com