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 |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2004-09-06 : 11:22:21
|
| Hi Reader,At the moment we have 50 identicle databases. I need some software to update them all with an updated view for example. Or I want to be able to add a new field to one of the tables in all the databases. Is there any way to do this?ThanksLeah |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-09-06 : 12:00:16
|
| Just a hint..sp_msforeachdb (undocumented sp) can be used across the databases...------------------------I think, therefore I am |
 |
|
|
|
|
|
Keeping those database's the same.