Get Information About Stored Procedures

Several system procedures provide information from the system tables about stored procedures.

• Get a Report with sp_help
  You can get a report on a stored procedure using sp_help. For example, you can get information on the stored procedure byroyalty, which is part of the pubs2 database, using:
• View the Source Text of a Procedure with sp_helptext
  To display the source text of the create procedure statement, execute sp_helptext.
• Identify Dependent Objects with sp_depends
  sp_depends lists all the stored procedures that reference the object you specify or all the procedures that it is dependent upon.
• Identify Permissions with sp_helprotect
  sp_helprotect reports permissions on a stored procedure (or any other database object).