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 |
|
PGG123
Yak Posting Veteran
55 Posts |
 Posted - 2003-04-09 : 15:39:15
|
| I'm updating the stored procedures on several Databases in my sql server 7 and I'm wondering if there's a way of doing it all at once. Currently, I'm updating the databases one at a time using Query analyzer. Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-09 : 15:41:05
|
| try creating a script and running it via osql against the databases.You can also use dmo (or dts) to transfer objects.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
sql command?