Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: extract stored procedure code

    Hi,

    Is there any command prompt utility to extract stored procedure / trigger source code from a database like defncopy in sybase?

    pl reply.

    Ram.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Use sp_helptext (just like on ASE) to get the contents of a stored procedure or trigger. If you want an automated method to get all the data out you need to look at Microsoft DTS (which is in Enterprise Manager).
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •