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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2008-01-24 : 15:06:21
|
| I created about 100 store procedures and now want to save them.How to save content for all of them? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2008-01-24 : 15:15:26
|
| 2000 or 2005?In any case you do it in EM or SSMSBUT, you shouldn't do it that wayYou should save the code to the server or pvcs (or both)all the time and when changes need to be made, you open those files, make your changes, save it, then compileNever make changes in the sproc windowBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2008-01-24 : 15:31:17
|
| I use 2005. Because I found another job and want to save all store procedures in a text file. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-25 : 09:44:29
|
| The best thing to do is a Generate Scripts - when you open the wizard , you will get an option of saving all stored procedures.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
List content for all store procedure