How can I export stored procedures in SQL Server 2005?

How can I export stored procedures in SQL Server 2005?

    Requires Free Membership to View

In SQL Server Management Studio, go to Object Explorer and navigate to the database. Right-click the database and select Tasks->Generate Scripts. A wizard will open. Follow the steps and you will be able to select all or individual database objects, including stored procedures. At the end of the wizard you can chose to script to the clipboard, a text file or a new query window.

This was first published in February 2008

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.