I am working on a program that creates a new database for each account that is created within the program. The tables are always going to structured identically. We are using MS SQL Server 2000
My questions is how can I institute a change that will effect every database on that server at the same time?
For example:
I suddenly want to add an email column in the users table. Well, obviously I have no intention of manually updating each and every db so that they all have an email column in the users table. I also do not want to simply enter the SQL into query analyzer, and one at a time, update each db.
How can I do this is one shot, no matter how many dbs there are or what changes I want made? Any help in this matter would be greatly appreciated.
Bob Gibilaro
Network Administrator
V. Alexander & Co., Inc.