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

    Unanswered: Extract Store procedure code with grants from the database

    All,

    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?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP
    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
  •