Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select CP.plan_handle
- From sys.dm_exec_cached_plans CP
- Cross Apply sys.dm_exec_query_plan(CP.plan_handle) As QP
- Where QP.objectid = Object_id(N'Procedure Name')
- And QP.dbid = DB_ID(N'Database Name');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement