SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object | Journey to SQL Authority with Pinal Dave

This is another popular question I receive. 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. Syntax sp_helptext @objname = 'name' sp_helptext [ @objname = ] 'name' [ , [ @columnname = ] computed_column_name Displaying… Continue Reading...

Source: SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object | Journey to SQL Authority with Pinal Dave