{"id":1265,"date":"2018-06-12T16:02:32","date_gmt":"2018-06-12T16:02:32","guid":{"rendered":"http:\/\/sezeromer.com\/?p=1265"},"modified":"2023-02-26T23:45:50","modified_gmt":"2023-02-26T20:45:50","slug":"sql-server-saving-changes-is-not-permitted-hatasi","status":"publish","type":"post","link":"https:\/\/sezeromer.com\/en\/sql-server-saving-changes-is-not-permitted-hatasi\/","title":{"rendered":"SQL Server Saving Changes is not Permitted Error"},"content":{"rendered":"<p>We usually get this error when we create and save a table in the database and then try to rearrange it. The solution is actually very simple. After I saved the table, I took it while trying to change a table&#8217;s property.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1266\" src=\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata.png\" sizes=\"(max-width: 603px) 100vw, 603px\" srcset=\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata.png 603w, http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata-300x281.png 300w\" alt=\"\" width=\"603\" height=\"564\" \/><\/p>\n<p>To do this, you need to enter the settings from SQL Server Management Studio. Once in the settings, we click on the Table and Database Designers option under the Designers tab. We will go through the changes here. In addition to the require table re-creation option, we are removing the tick mark and the problem is getting out of hand.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1267\" src=\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata-2.png\" sizes=\"(max-width: 848px) 100vw, 848px\" srcset=\"http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata-2.png 848w, http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata-2-300x202.png 300w, http:\/\/sezeromer.com\/wp-content\/uploads\/2018\/06\/sql-hata-2-768x517.png 768w\" alt=\"\" width=\"848\" height=\"571\" \/><\/p>\n<p>If you have any questions, please feel free to mail or comment.<\/p>","protected":false},"excerpt":{"rendered":"<p>We usually get this error when we create and save a table in the database and then try to rearrange it. The solution is actually very simple. After I saved the table, I took it while trying to change a table&#8217;s property. To do this, you need to enter the settings from SQL Server Management [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225],"tags":[492,295,490,491,208,489,488],"class_list":["post-1265","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-changes","tag-hata","tag-permitted","tag-save","tag-sql","tag-table","tag-tablo"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/posts\/1265"}],"collection":[{"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/comments?post=1265"}],"version-history":[{"count":4,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/posts\/1265\/revisions"}],"predecessor-version":[{"id":1325,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/posts\/1265\/revisions\/1325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/media\/1161"}],"wp:attachment":[{"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/media?parent=1265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/categories?post=1265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sezeromer.com\/en\/wp-json\/wp\/v2\/tags?post=1265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}