In SQL server 2000, I'm adding some columns into tables using Management Studio. Is there any way I can get the changes into a sql script, so that I can run the script in another sql server.
Basically, I want to sql server to generate a script for me whatever I have done in sql mangement studio. Is that possible?
Thank in advance!