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 |
|
tabdeen
Starting Member
1 Post |
 Posted - 2009-03-09 : 15:40:17
|
| Hi All, I have 20 different databases that have the same exact structure. In the old times when they were 10 it was fairly easy to update them all with new or modified objects. My Question is can I share: functions, stored procedures and views across all of the databases. What should i be looking for?if not is there is a way that i can place my SQL scripts and run them for all of the databases?thank you for your timethanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 15:58:06
|
| Yes with Sp_Msforeachdb system store proc. |
 |
|
|
|
|
|
Sharing Objects Across Databases