backup store procedures....

  • Do you know how backup only my store procedures and later restore them?

  • You can script the stored procedures to a file, then back that up.

    Right-click on a database in Enterprise Manager or Management Studio and look for "Generate Scripts...".  Use the formatting options to include DROP and CREATE commands, as well as object-level (EXECUTE) permissions.

    Test the script on a copy of the original database to make sure everything works.  Some obsolete procedures may not compile because they refer to objects that have been dropped or renamed.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply