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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-06 : 07:39:42
|
| Matias writes "How do backup only stored procedure of some database ?or schedule a script of stored ?SQL 7.0Thank youMatias" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-06 : 07:47:45
|
| The best way is to keep the stored procedures in some sort of source control, for example VSS. If you don't wanna do that however...The procedures are backuped with the database they are in if you back that up. The code for them is kept in the syscomments system table. I guess you could back that table up if you want only the procs.Another option is to have a look at SQLDMO to script the procs automatically. |
 |
|
|
|
|
|
Backup stored procedure