Load stored procedure

Hi all,

I couldn't find some tables in the sql database, so looking with sql management I realized that they are stored procedures. Is it possible to load these stored procedure? And how?