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

Plan Handle for PRoc

SQLSoldier Oct 30th, 2017 80 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
  1. Select CP.plan_handle
  2. From sys.dm_exec_cached_plans CP
  3. Cross Apply sys.dm_exec_query_plan(CP.plan_handle) As QP
  4. Where QP.objectid = Object_id(N'Procedure Name')
  5. And QP.dbid = DB_ID(N'Database Name');
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