Travelling on through software development
EXEC sp_HelpText 'your procedure name'
Found in http://stackoverflow.com/questions/467482/how-do-i-programmatically-retrieve-sql-server-stored-procedure-source-that-is-ide