• You can make use of sys.dm_tran_locks DMV to get that information. Here is an example.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga