Retreive the Schema of a Stored Procedure or Function

• Anthony peiris

  SSC Enthusiast

  Points: 199

  More actions

  September 7, 2010 at 9:05 pm

  #225926

  Comments posted to this topic are about the item Retreive the Schema of a Stored Procedure or Function

• Mike01

  SSChampion

  Points: 11413

  More actions

  September 9, 2010 at 6:34 am

  #1218555

  This doesn't return the schema of a preocedure. It returns the parameters

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• david.avraamides

  SSC Enthusiast

  Points: 134

  More actions

  September 9, 2010 at 11:51 am

  #1218822

  Why not just use [font="Courier New"]sp_helptext[/font]?

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 18, 2016 at 7:14 am

  #1879861

  Thanks for the script.