Post reply

system procedure to get the details of the user defined stored procedure

  • January 20, 2010 at 3:05 am

    #138130

    HI All,

    Is there any stored procedure to find parameters and detials that has been used in the user defined stored procedures.

  • January 20, 2010 at 3:20 am

    #1105920

    select * from sys.sql_modules where definition like '%proc name%'

    this will give you the definition of sql objects...like sps,funcs,views....

    also

    sp_helptext procname

    will give you the proc definition

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • January 20, 2010 at 3:24 am

    #1105923

    k.solai 53753 (1/20/2010)

    HI All,

    Is there any stored procedure to find parameters and detials that has been used in the user defined stored procedures.

    sp_help <ProcedureName>

    gives the list of parameters...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply