View Stored Procedure Source Code

If you want to see the raw SQL behind your stored proc (like you can
in SQL Server Management Studio) then use:

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