I'm trying to monitor the progress of a bunch of labor intensive store-procs I'm
I'm executing the procs from MSSQL7's Query Analyzer (and, I run them from perl
scripts (linked via MSSQL7's perl libraries)).
I'm not having any luck with inbedded PRINT commands (telling me where I am in in
a particular proc) - as the PRINT statements don't seem to go to output until the
stp has finished (I suppose the PRINT's output goes to some TEXT buffer that
doesn't get flushed until the proc's end?).
All my insert/update/delete transacitions are inside of BEGIN TRAN/COMMIT
statements. Further, I've named each TRAN uniquely (ie., BEGIN TRAN INSERT_1A).
In the Sybase Server, one was able to do a "select * from master..sysprocesses"
and observe the tran_name (for a spid) that was being worked on at the time.
Is there some similar command I can query, in MSSQL7, to see what tran_name is
currently being executed?