If I am to add a new column to a table in SQL Server Management Studio 2008 via the interface/WYSIWYG (as opposed to writing a SQL query) this will, behind the scenes, create a SQL query which it will execute to perform the requested changes.
Is there any way to capture these SQL queries so that I am able to easily execute them on another server, without using SSMS, or re-writing the query.