Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009

    Unanswered: Extract Store procedure code with grants from the database


    Can anyone tell me how to extract an stored procedure code from the database as one file(.sql) per stored procedure?

    I need one file each for one stored procedure not all stored procedure code in one file. Is it possible to do it with some tools or any specific procedures?


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Yes this is possible, but the exact procedure varies slightly from one SQL version to another. SQL-DMO is the best answer if you need to stay independant of SQL versions. Checking the scripting parameters is the best answer for a "one shot" scripting exercise.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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