Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: Getting store procedures code

    Hi ,

    can you tell me if it is possible to get the code of a store procedure that is alredy running in the database.

    Thanks in advanced

    Ivo

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya

    sp_helptext <Procedure name> will give you the code.

    1> sp_helptext sp_help
    2> go

    Cheers
    Willy

Posting Permissions

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