SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
How to see text/content/code of Stored Procedure. System stored procedure that prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, or view.
From this you can view Stored Procedure to display by text (code)
sp_helptext @objname = 'sp_name'
sp_helptext @objname = 'sp_viewemp'