Script all stored procedures in Management Studio 2005

Question

In Enterprise Manager you could script all SPs in a database through the right click menu, is there a way to do it in Management Studio?

Answer 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.

Answer 2

1. Go to Microsoft SQL Server Management Studio
2. Select the database
3. Right click on selected database
4. Select 'Tasks'
5. Select 'Generate Scripts'
6. Select 'Next'
7. Select / tick 'Select specific database objects'
8. Tick 'Stored Procedures'
9. Select 'Next'
10. Select the option where do you want to save the file