Clicking Yes, committed the change to those tables. This is an example of a change that does not require a table to be re-created so is allowed in SSMS 2008 by default.

This article helps you resolve the problem that occurs when you try to modify a large table by using the table designer in SQL Server Management Studio. This behavior occurs because of the transaction ...