select b.name from sys.syscomments a join sys.objects b

on a.id=b.object_id and a.text <> '' and b.type_desc in ( 'SQL_STORED_PROCEDURE','SQL_SCALAR_FUNCTION')