{"id":1421,"date":"2020-02-27T08:35:08","date_gmt":"2020-02-27T08:35:08","guid":{"rendered":"http:\/\/blog.inetmar.com\/?p=1421"},"modified":"2024-12-06T15:47:48","modified_gmt":"2024-12-06T12:47:48","slug":"mssql-saving-changes-not-permitted-hatasi","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mssql-saving-changes-not-permitted-hatasi\/","title":{"rendered":"MSSQL Saving Changes Not Permitted Hatas\u0131"},"content":{"rendered":"<p>Merhaba,<\/p>\n<p>Management Studio \u00fczerinde \u00e7al\u0131\u015fma yaparken, tablo tipi veya tablo ad\u0131 de\u011fi\u015ftirmek istedi\u011finizde a\u015fa\u011f\u0131da ki gibi bir hata ile kar\u015f\u0131la\u015fabilirsiniz.<\/p>\n<p><em>\u201cSaving 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\u2019t be re-created or enabled the option Prevent saving changes that require the table to be re-created.\u201d<\/em><\/p>\n<p><a href=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1422 \" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_1-300x244.png\" alt=\"\" width=\"385\" height=\"313\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_1.png 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_1-60x49.png 60w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_1-150x122.png 150w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/a><\/p>\n<p>Hata, kulland\u0131\u011f\u0131n\u0131z server veya veritaban\u0131n\u0131zdan de\u011fil, MSSQL Management Studio program\u0131n\u0131z\u0131n ayarlar\u0131ndan kaynaklanmaktad\u0131r.<\/p>\n<p>Management Studio Program\u0131n\u0131zda \u015eimdi S\u0131ras\u0131yla <strong>Tools &gt; Options<\/strong>\u2018a girelim. A\u00e7\u0131lan ekranda <strong>Designers\u2019e\u00a0<\/strong>t\u0131klay\u0131p <strong>Table and Database Designers\u2019e<\/strong> t\u0131klayal\u0131m, gelen ekranda\u00a0<strong>Prevent saving changes that require table re-creation\u00a0<\/strong>se\u00e7e\u011finin i\u015faretini kald\u0131ral\u0131m ve OK ile kaydedelim. \u00a0Bu i\u015flemleri yaparak bu hatay\u0131 gidermi\u015f olduk, tablo tipi, tablo ad\u0131 vs. de\u011fi\u015fikli\u011fi yapabilirsiniz.<\/p>\n<p><a href=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1423\" src=\"https:\/\/blog.inetmar.com\/wp-content\/uploads\/2020\/02\/mssql_2-300x174.jpg\" alt=\"\" width=\"378\" height=\"219\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_2.jpg 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_2-60x35.jpg 60w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2020\/02\/mssql_2-150x87.jpg 150w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/a><\/p>\n<p>Farkl\u0131 bir makalede g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n<p><a class=\"waffle-rich-text-link\" href=\"https:\/\/www.inetmar.com\/domain\/tr-domain-kayit\/\">com.tr domain<\/a> pazar\u0131nda rekabet avantaj\u0131 elde etmek i\u00e7in do\u011fru ad\u0131mlar\u0131 at\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba, Management Studio \u00fczerinde \u00e7al\u0131\u015fma yaparken, tablo tipi veya tablo ad\u0131 de\u011fi\u015ftirmek istedi\u011finizde a\u015fa\u011f\u0131da ki gibi bir hata ile kar\u015f\u0131la\u015fabilirsiniz. \u201cSaving changes is not permitted. The changes you have made require the following tables to&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,48],"tags":[],"class_list":["post-1421","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-win-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=1421"}],"version-history":[{"count":5,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1421\/revisions"}],"predecessor-version":[{"id":9664,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1421\/revisions\/9664"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=1421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=1421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=1421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}