Subscribe to this blog
Briefcase
Print
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!
Posted by MEGANATHAN K on 24 March 2010
It's really help ful for me.
Thanks
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
Tanks