SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

A little restriction that prevent changing tables in SQL Server 2008

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and we want to change the datatype or adding any column in a table with SSMS (SQL Server Management Studio), and the SSMS will said to us that changes in the table are not allowed you should to recreate table insted of changing it!

Yes, this is the worry situation that you cannot wait or you have many things to do after that change etc etc. Considering that you have nice experience with data and table structures and to avoid this little restriction you should go to the SSMS Tools > Options > Designers | to uncheck the option "Preventing saving changes that require table re-creation".


That's it for the beginner users to avoid the restriction that prevent changing tables in SQL2k8/SQL2k5!

Have a nice SQLing!

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...


Posted by MEGANATHAN K on 24 March 2010

It's really help ful for me.


Posted by Markus on 24 March 2010

Yep, I found that one too. I was attempting to change a table that was empty so it really did not matter to me. I am sure this will come up alot with people migrating to SQL 2008.

Posted by tstaker on 24 March 2010

Thanks, I was trying to find that one, I guess it was too obvious.

Posted by andres-388127 on 30 March 2010


Leave a Comment

Please register or log in to leave a comment.