Have figured it out by using this query:

SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan, plan_handle

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

CROSS APPLY sys.dm_exec_query_plan(plan_handle)

WHERE TEXT like '%%'