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.
1.4m articles
1.4m replys
5 comments
57.0k users