The following query will list all user-defined executable objects (procedures, functions, views):
select name
from sysobjects
where objectproperty(id, 'IsExecuted') = 1
and objectproperty(id, 'IsMSShipped') = 0
... until the collector arrives ...