Use sp_iqprocedure to show information about system and user-defined procedures in a database.
sp_iqprocedure sp_test proc_name proc_owner proc_defn replicate srvid remarks sp_test DBA create procedure N (NULL) (NULL) DBA.sp_test(in n1 integer) begin message‘sp_test’end