locked
show source code for many stored procedures RRS feed

  • Question

  • For one stored procedure it is possible to see the source using modify. Is there a way to show the sources for many SPs at one time? I can see the names of the SPs but not the contents of all of them.

    Wednesday, July 9, 2014 3:30 PM

Answers

  • Found my own answer. If you are looking to get the sources for multiple store procedures at one time, right click on the database name, the Tasks, then Generate scripts.

    Very manual, but for a "once-in-a-while" need, works just fine.


    • Edited by roadkill4299 Wednesday, July 9, 2014 4:11 PM
    • Marked as answer by roadkill4299 Wednesday, July 9, 2014 4:11 PM
    Wednesday, July 9, 2014 4:11 PM

All replies

  • Found my own answer. If you are looking to get the sources for multiple store procedures at one time, right click on the database name, the Tasks, then Generate scripts.

    Very manual, but for a "once-in-a-while" need, works just fine.


    • Edited by roadkill4299 Wednesday, July 9, 2014 4:11 PM
    • Marked as answer by roadkill4299 Wednesday, July 9, 2014 4:11 PM
    Wednesday, July 9, 2014 4:11 PM
  • Hi,

    you can script out store procedure by following steps.

    1. select database and right click to Tasks.
    2. select Generate scripts 
    3. Press Next
    4. Select specific database objects.
    5. Expand stored Procedure.
    6. Select stored procedure you want to script out you can select all using button at bottom.
    7. Next you have different options to save ie as file or on new query window.

    Regards

    Hope this helps.

    if you think this helps you please mark this as answer.

    • Proposed as answer by kaushall_shah Thursday, July 10, 2014 9:04 AM
    Wednesday, July 9, 2014 4:27 PM