sreimer Asked: 2012-10-24 08:21:25 +0800 CST2012-10-24 08:21:25 +0800 CST 2012-10-24 08:21:25 +0800 CST Altering a table via SQL Server Management Studio - get SQL 772 Is there a way to get the ALTER statement run by the management studio when altering a table in the design view? sql-server-2008 1 Answers Voted Best Answer sreimer 2012-10-24T08:54:21+08:002012-10-24T08:54:21+08:00 I found the generate change script button. It appears after making a change via the designer window. This allowed me to run the changes on other hosts with a query rather than going through the GUI again.
I found the generate change script button. It appears after making a change via the designer window.
This allowed me to run the changes on other hosts with a query rather than going through the GUI again.