I read this article quickly and as soon as I saw you using the Profiler I stopped reading thinking this isn't the easiest way for sure... there must be a DMV that exists...

So after some research I came up with the following to find the unused stored procedures... take it for what it is worth:

Select *

from sysobjects S

left join sys.dm_exec_procedure_stats X on X.object_id = S.id

where S.xtype in ('P' ,'X')

and X.object_id is null

Enjoy.

JG