I have a server with over 50 databases, they are all exactly the same, for liability reasons we need to keep them separate. Every week or so I need to run a script to update them, it is the same script for all 50 databases.
Is there a way to run the script ONCE and have it update ALL selected databases ? It is a pain to have to run it 50 times.
I am using MS SQL 2008 RC2.