For some reason I had forgotten about the Save Change Script Dialog Box; an excellent tool that automatically generates Microsoft SQL 2000 change scripts for you.
I am trying to script out all SQL 2K DB changes, to make the migration of SQL 2K database updates from development to test to production easier, more efficient, and standardized.
As I make changes to my dev environment database, I compile all of the scripts that are used to make those changes into one .sql file which I will execute on the "test" SQL 2000 database server and, if all goes well, on the production SQL 2000 database server.
Apparently you can do the same thing in MS SQL 2005 using Generate Change Script.
Via SQL Server Central's forums.