{"id":160,"date":"2009-07-15T11:58:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=160"},"modified":"2009-07-15T11:58:00","modified_gmt":"1970-01-01T00:00:00","slug":"sql-server-2008-de-tablo-guncelleme-hatasi-saving-changes-is-not-permitted","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2009\/07\/15\/sql-server-2008-de-tablo-guncelleme-hatasi-saving-changes-is-not-permitted\/","title":{"rendered":"SQL Server 2008 de Tablo G\u00fcncelleme Hatasi – Saving changes is not permitted"},"content":{"rendered":"

SQL Serverda olusturdugumuz bir tabloda degisiklik yapmak istedigimizde Saving changes is not permitted… hatasi aliriz. Bunun sebebi degistirilmek istenilen tablonun drop edilip yeniden create edilmesidir. SQL Server’da default olarak bu isleme sinirlandirilmistir. Tam olarak aldiginiz hata metni ve resmi asagidaki gibidir.<\/span><\/p>\n

.<\/a><\/p>\n\n \n \n
\n

Saving changes is not permitted. The changes you have made require the <\/span><\/p>\n

following tables to be dropped and re-created. YOu have either made changes <\/span><\/p>\n

to a table that can’t be re-created or enabled the option Prevent saving <\/span><\/p>\n

changes that require the tables to be re-created.<\/span><\/p>\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n <\/tbody>\n<\/table>\n

 <\/span><\/p>\n

 <\/p>\n

\"\" <\/span><\/p>\n

Bu hatayi aliyorsaniz tek yapmaniz gereken Tools->Options Menusune girmek ve açilan ekranda Designer menüsü altindaki table and database designer alt menüsünden prevent saving changes that require table re-creation checkboxini temizlemek.<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

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

SQL Serverda olusturdugumuz bir tabloda degisiklik yapmak istedigimizde Saving changes is not permitted… hatasi aliriz. Bunun sebebi degistirilmek istenilen tablonun drop edilip yeniden create edilmesidir. SQL Server'da default olarak bu isleme sinirlandirilmistir..<\/p>\n","protected":false},"author":517,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[422],"tags":[4352,4423,5103],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/160"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/517"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=160"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}