View contents of a Stored Procedure (quickly)

USe the procedure ‘SP_HELPTEXT ’ to view the content of the stored rpocedure from T-SQL . If you are extensive user of the T-SQL stored procedure, you may assing ehte short key from Tools -> Options -> Keyboard and type in SP_HELPTEXT for a key of your choice.