Script all stored procedures in Management Studio 2005
Solution 1:
You can right click on the database and to go Tasks -> Generate Scripts...
This will allow you to script all or selected objects (schema, stored procedures, tables, users and views) with specific options.
Solution 2:
- Go to Microsoft SQL Server Management Studio
- Select the database
- Right click on selected database
- Select 'Tasks'
- Select 'Generate Scripts'
- Select 'Next'
- Select / tick 'Select specific database objects'
- Tick 'Stored Procedures'
- Select 'Next'
- Select the option where do you want to save the file
Solution 3:
Sure. All you need to do is to is click on the Stored Procedure in the Object Explorer and then highlight all the stored procedures in the Summary pane. Then simply right click and choose the scripting option that you prefer.
Good luck