Advertisement
SQLSoldier

Untitled

Sep 29th, 2013
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.21 KB | None | 0 0
  1. With Test1
  2. As (SELECT *
  3.     FROM Production.Product WITH (NOLOCK))
  4. Select Distinct object_name(resource_associated_entity_id), TL.*
  5. From sys.dm_tran_locks TL
  6. Cross Join Test1 T1
  7. Where request_session_id = @@SPID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement