How to find lines of Code Written in a Store Procedure, Using SQL Server 2005

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  February 12, 2009 at 9:40 pm

  #134673

  Hi,

  I would like to know, how to find lines of Code Written in a Store Procedure using SQL Server 2005. Please help.

  With Regards

  Dakshina Murthy

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  February 12, 2009 at 9:50 pm

  #943347

  Hello,

  If you just want to get a code listing then you can execute the system SP sp_helptext from within the relevant DB

  e.g. sp_helptext ‘mySPname’

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  February 13, 2009 at 9:50 pm

  #944034

  Hi,

  Thanks for the support, i have found the query to find the lines of code in a Given SP for a DB in the following Link, this will be usefull.

  http://stackoverflow.com/questions/291574/query-to-list-sql-server-stored-procedures-along-with-lines-of-code-for-each-proc

  With Regards

  Dakshina Murthy