Thursday, May 10, 2012

Cannot ALTER TABLE in SQL2008/SQL2008 R2


If you want to modify a table property through the UI which requires a table recreation, then you need to change the following options in Management Studio:
Tools ->Options-> Designers -> Table and Database Designers -> uncheck the option "Prevent saving changes that require table re-creation"
It worked for me.
Welcome to all ..This is an short blog.IT will help to you to overcome from programming problems...Here we goooooo!!!!!!!!!!!!!!!!!!