CODEWITHSUNDEEP
sql-serverssms
Marshall
Marshall

Reputation: 1083

Script all stored procedures in Management Studio 2005

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?

Upvotes: 49

Views: 65279

Answers (5)

Raj
Raj

Reputation: 131

  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

Upvotes: 13

wcm
wcm

Reputation: 9291

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

Upvotes: 7

Nick DeVore
Nick DeVore

Reputation: 10176

If you right click on the database name, the bottom option is "Generate Scripts" which will then launch a wizard to generate scripts for the whole DB or specific objects inside.

Upvotes: 4

sebastiaan
sebastiaan

Reputation: 5917

Right click the database, choose Tasks, choose Generate Scripts.., click Next, Next again, choose Stored procedures, Next, Select All, Finish.

Presto!

Upvotes: 6

Brian Kim
Brian Kim

Reputation: 25366

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.

Upvotes: 88

Related Questions