Advertisement
SQLSoldier

Plan Handle for PRoc

Oct 30th, 2017
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.20 KB | None | 0 0
  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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement