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 type -------- ------ ---------------- byroyalty dbo stored procedure
Data_located_on_segment When_created --------------------------- -------------------- not applicable Jul 10, 1997 4:57PM Parameter_name Type Length Prec Scale Param_order -------------- ------ ------ ---- ----- ----------- @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.
