Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- With Test1
- As (SELECT *
- FROM Production.Product WITH (NOLOCK))
- Select Distinct object_name(resource_associated_entity_id), TL.*
- From sys.dm_tran_locks TL
- Cross Join Test1 T1
- Where request_session_id = @@SPID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement