| Aleksander Stukov 2006-10-24, 6:28 pm |
| Hi there,
I'm developing a function in Centura 1.5 (very old programming
languaje) to track down locks in SQL Server. This function listens for
a very specific error code (Time Out errors), and then performs some
selects commands on sys.sysprocesses table trying to retrieve all the
info for the locked transanction and the locking transanction (I'm
trying to get who's blocking, who is blocked and stuff like this).
The problem is that I cannot retrieve the info for the locking tran
since when a time out event triggers, it performs a rollback
instruction (AFAIK), thus unlocking transanction, and thus resetting
the locking field to NULL (this field stores the SPID number for the
locking transanction).
I've surfing aroud groups and the Internet (as well as MSDN) but I did
not find anything useful =BFdo you have any ideas?. Please notice I
cannot use any tracking system like ODBC trace nor SQL Server trace (I
must do it from inside Centura).
Thanks for all!,
Regards,
A=2E Stukov.
|