We have a client who has approximately 200 identical databases - ALL ON THE SAME SERVER.
He needs to be able to update just one field entry in just one table - for EACH database.
The tables and the fields and the entries are all identical.
Rather than logging into each database and making the update, we would like to enter all of his database names, usernames and passwords into an array, and then then be able to perform the same update with each database using just one script.
Unless you can think of an easier way, we need this script to be able to perform this function one time.
Need it fast and cheap.