tag:blogger.com,1999:blog-25940845215735799412024-10-24T00:36:33.987-07:00SQL ServerAnonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2594084521573579941.post-87977949953015129572010-04-29T07:54:00.000-07:002010-04-29T08:02:03.961-07:00<span style="font-family: georgia;"><br />In SQL server 2008 modifying table is not permitted by default. From the table designer if you try to modify a table it will display a message : </span><br /><span style="font-family: georgia;">"Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.<o:p></o:p> "</span><br />All you can do is Cancel it.<br /><br /><span style="color: rgb(153, 0, 0);">Solution:</span><br />Go to Tools > Options > Designers > Table and Database Designers :: Form the left pane uncheck the option " Prevent saving changes that require table re-creation. > OKAnonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.com0