Fetch a Stored Proedure using osql

• cmbsurfer

  SSC Journeyman

  Points: 75

  More actions

  January 6, 2009 at 10:12 pm

  #199836

  Hi,

  I want to modify an existing stored procedure and therefore i want to copy the stored procedure. How can I do it in osql only? I know SQL management console can be used but this is MSDE 2000

  Thanks

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  January 7, 2009 at 2:36 am

  #922366

  Use the procedure "sp_helptext "

  --Ramesh
  

  ---

• cmbsurfer

  SSC Journeyman

  Points: 75

  More actions

  January 7, 2009 at 3:12 pm

  #922953

  Thanks for your hint. I manage to script the stored procedure using that. Thanks again.