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?
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.
2.1m questions
2.1m answers
60 comments
57.0k users