• If it is currently in the cache then use the query below (replacing the check with your SP name).

    SELECT UseCounts ,

    Objtype ,

    [text] ,

    query_plan

    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 '%check%'

    Note: It can take a while to run, so please plan accordingly.