• You can query the cache to see what procedures are in it and compare that against the list of procedures. However, just because a procedure is not currently in cache doesn't mean it doesn't get used. It just means it hasn't been used recently, but may have just aged out of the cache prior to your query.

    If you think it'll help, with very serious caveats in place, I'd try going against sys.dm_exec_procedure_stats. This will give you the object ID and it marks whether or not it's a stored procedure.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning