Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
 Posted - 2010-12-06 : 01:42:47
|
| I have 500 stored procedures in a database.I need to script all those in 500 different files.what is the best way to do it..?Karthikhttp://karthik4identity.blogspot.com/ |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-06 : 01:46:18
|
| You want to do it through SSMS or you have the DB in source control like TFS?PBUH |
 |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2010-12-06 : 01:48:45
|
| I have SSMSKarthikhttp://karthik4identity.blogspot.com/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-06 : 02:48:56
|
| Right click the database>>Tasks>>GenerateScripts>>Choose Objects(In your case select stored procedure)>>Click Next>>Set Scripting Options(There will be a radio button Single File and Single file per object).Check Single file per object which will generated SP files for each sp in the DB in the specified directory.PBUH |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2010-12-06 : 04:35:29
|
| after select GenerateScripts it leads me to Script Wizard.. and from there I am not getting the radio button..I am using SQL server 2005Karthikhttp://karthik4identity.blogspot.com/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-06 : 06:12:01
|
| You need to select the database object you want to script.In your case select the stored procedure.PBUH |
|
|
|
|
|
|
Script procedures in different files