Karthik (12/14/2007)

---

[font="Verdana"]Right click on the database in SSMS. Go to Tasks->Generate Scripts.

Go with the defaults in the wizard till you come to the page to select object types. Select Stored...

Thanks rcavill .

Does anyone know of a way to export Stored procedures from a database to individual files with the same names as the respective SPs?

Gracias

sushila (12/12/2007)

---

In addition to Robert's post I just wanted to mention that the Help provided with SQL Server (BOL - Books on line) is pretty extensive & comprehensive and that's...

rcavill (12/12/2007)

---

From within SQL-EM, highlight the list of stored procedures within the database.

After right click and choosing Tasks-->Generate SQL Scripts, the "Generate SQL Scripts" window appears.

the [General] tab will show...

Following up on the solution provided by Sushila, is there a way to script all stored procedures in the database to seperate files with the same names as the stored...