SELECT TOP 1
@transactionID = req_transactionID
FROM
master..syslockinfo l
INNER JOIN
master..sysprocesses p ON l.req_spid = p.spid AND l.rsc_dbid = p.dbid AND p.spid = @@spid
WHERE
l.rsc_dbid = db_id() AND p.open_tran != 0 AND req_transactionID > 0
ORDER BY
req_transactionID