Getting 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, like this:

sp_help byroyalty 
Name       Owner   Object_type        Create_date
--------   ------  ----------------
byroyalty  dbo     stored procedure   Jul 27 2005 4:30PM

(1 row affected)
Parameter_name Type    Length   Prec  Scale  Param_order Mode
-------------- ------  ------   ----  -----  ----------- 
@percentage    int          4   NULL   NULL            1 
 
(return status = 0)

You can get help on a system procedure by executing sp_help when using the sybsystemprocs database.