Skip to main content

Posts

Showing posts from May, 2015

Cannot modify table ( using microsoft sql server management studio 2008 )

Problem - I created a table, once its created I come to know that I need to add a column to that table,  I try to add a field but I get an error "Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created." Solution - enable saving changes that require dropping of tables by going to "tools->options->designers->Table and database designers" and unchecking "Prevent saving changes that require table re-creation"