Hi PB_BI,
Thanks for the reply, but i am using the following query,
SELECT top 1 lock_object_id
FROM $System.DISCOVER_LOCKS
WHERE Lock_type = 4
I googled but i found out that i cannot use, Iff in the above query.
Do you know some other alternative to do so, could you please share if doing the above is possible.