Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @TABLE SYSNAME,
- @Schema sysname;
- SET @TABLE = QUOTENAME(N'Product');
- SET @Schema = QUOTENAME(N'dbo');
- WITH XMLNAMESPACES ('http://schemas.microsoft.com/sqlserver/2004/07/showplan' AS sqlx)
- SELECT object_name(st.objectid, st.dbid) AS ObjectName,
- qp.query_plan AS QueryPlan,
- st.text AS ObjectText
- FROM sys.dm_exec_cached_plans AS cp
- OUTER APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp
- OUTER APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
- WHERE qp.dbid = DB_ID()
- AND qp.query_plan.exist('//sqlx:Object[@Schema=sql:variable("@Schema")]') = 1
- AND qp.query_plan.exist('//sqlx:Object[@Table=sql:variable("@Table")]') = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement