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 |
|
Zcumbag
Starting Member
3 Posts |
 Posted - 2008-06-04 : 11:24:57
|
| Hello.Is there a way, through t-sql or through SQL Server Management Studio, to retrieve (or export to file) all procedure code for all my stored procedures?I would like this for backup reasons. Possible? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 11:33:23
|
| You can script with Generate script task. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Zcumbag
Starting Member
3 Posts |
Posted - 2008-06-05 : 08:14:34
|
| Allright. That solved it. Rightclicking on my database in the treeview (in SQL Management Studio) -> Tasks -> Generla Script.Thakns. |
|
|
|
|
|
|
Get procedure code of ALL Procedures in database