Stored procedures are stored in the database (that's the reason they are called stored procedures). The text is stored in system tables - you can retrieve if from
sys_modules
like this:
select * from sys.sql_modules where object_id=object_id('MyStoredProcedure')