show source code for many stored procedures

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.

Answer 1

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.

Answer 2

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.