How can i modify a table in design mode in SQL Server 2008 ?

Question

I used to modify the tables in SQL Server 2005 but now after creating a table, I want to alter some entites but the SQL Server 2008 never let me do it.

Is it about the configuration scope of the SQL Server 2008? or How ?

Regards Bk

Answer 1

I assume that you are using SQL Server Management Studio. In the Tools - Options menu, select the Designers node, and under Table options, uncheck "Prevent saving changes that require the table to be re-created".