sp_lock and sp_who

[fatherjack]

Is there any way to write a line to a table showing who had a lock at a particular time?

We have a need to rollback transactions that persist for too long and cause application errors. what i want to do is to dump the details of the connection into a table for analysis later.

i am thinking along the lines of
SELECT loginname
FROM sp_who
WHERE spid in
(
SELECT spid
FROM sp_lock
)
or something!!!!

any ideas anyone?

[MAK]

use profiler.

[fatherjack]

MAK, can you use profiler from within a SQL job and output to a table? I was not aware of this, can you post any sample code please?

[MAK]

use windows scheduler.. or refer this link please

http://forums.databasejournal.com/sh...threadid=34847