Returning query plans for all cached triggers The following example returns the query plans of all cached triggers. SELECT plan_handle, query_plan, objtype FROM sys.dm_exec_cached_plans CROSS APPLY sys.dm_exec_query_plan(plan_handle) WHERE objtype ='Trigger'; GO
