Script all stored procedures in Management Studio 2005

sql-server ssms enterprise-manager
Marshall picture Marshall · Oct 6, 2008 · Viewed 63.4k times · Source

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

Brian Kim picture Brian Kim · Oct 6, 2008

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.

Related questions

SQL Server Management Studio: Import quietly ignoring 99.9% of data

The Problem i'm trying to import data into a table using SQL Server Management Studio's Import Data task. It only brings in 26 rows, out of the original 49,325. (Edit: That's where 99.9% comes from: (1-26/49325)*100 = 99.9% Using DTS in Enterprise Manager correctly brings …

Read More
How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More