Access to Stored Procedure

• jaypak23

  SSC-Addicted

  Points: 417

  More actions

  November 5, 2003 at 9:33 am

  #358506

  Anyone know if there is a way to access the actual text of a stored procedure from the system tables? As in when you click properties on a sproc in enterprise manager and view the actual text of the sproc.

  Another option would be to read it using .Net if anyone knows if that is possible.

  Thanks!

  JP

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  November 5, 2003 at 9:40 am

  #480943

  sp_helptext your_sp_name

• Vijaya Kumar Gulappa

  SSChasing Mays

  Points: 633

  More actions

  November 5, 2003 at 9:52 pm

  #481010

  You can use syscomments system table to retrieve the actual text of your SP.

  select text from syscomments where id = object_id(<your sp name>)

  Note:Your sp should not be encrypted. This system table does not show encrypted object.

  Blog: Gulappa

• techbrain

  SSC Rookie

  Points: 27

  More actions

  November 6, 2003 at 4:45 am

  #481039

  Right Click on the procedure name in Enterprise Manager and select "Generate SQL Script" form "All Tasks"