{"id":716,"date":"2013-08-03T00:50:36","date_gmt":"2013-08-03T00:50:36","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=716"},"modified":"2016-07-08T22:49:51","modified_gmt":"2016-07-09T02:49:51","slug":"saving-changes-is-not-permitted-sql-server-tables","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=716","title":{"rendered":"Saving changes is not permitted (SQL Server tables)…"},"content":{"rendered":"

You upsize your\u00a0tables up to the SQL Server but you used some BIT fields and\/or you want to make some other table changes.\u00a0 So, you navigate to the first table and uncheck the *Allow Nulls* for your BIT field and make your other adjustments and you go to Save.\u00a0 Instead of the table saving you get…<\/p>\n

\"SavingChanges\"<\/p>\n

At first, you think you did it wrong so you try again only to get the above.\u00a0 Well, that’s not going to work!\u00a0 Don’t panic, there’s a quick and easy fix…\u00a0 You do not have to close the table you just made the adjustments to.\u00a0 Just go to Tools<\/strong> > Options<\/strong> > Designers<\/strong> > Table and Database Designers<\/strong> and uncheck *Prevent saving changes that require table re-creation<\/strong>* and click *OK<\/strong>*\u00a0 Now, you can return to your table and click *Save<\/strong>*\u00a0with no more issues.<\/p>\n

\"SQLServerOptions\"<\/a><\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

You upsize your tables up to the SQL Server but you used some BIT fields and\/or you want to make some other table changes. So, you navigate to the first table and uncheck the *Allow Nulls* for your BIT field and make your other adjustments and you go to Save. Instead of the table saving […]<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,63,29],"tags":[18,65,28,27],"class_list":["post-716","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-database-design","category-error-messages","tag-database-design","tag-error-messages","tag-sql-server","tag-upsize","odd"],"a3_pvc":{"activated":true,"total_views":875,"today_views":0},"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=716"}],"version-history":[{"count":8,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":1279,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions\/1279"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}