Need a unique gift idea?
A Pastebin account makes a great Christmas gift


SQLSoldier Sep 29th, 2013 82 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand