SQL SERVER – Stored Procedure to display code (text) of Stored

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)

Syntax
sp_helptext @objname = 'sp_name'


sp_helptext @objname = 'sp_viewemp'