Saving change is not permitted MS SQL 2008

May 4, 2009

Been battling with MS SQL 2008 and ran across the issue (it’s actually a feature!) of not being able to save changes made to a table in designer view. I got the following error:

Saving change 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 cant be re-created or enabled the option Prevent Saving changes that require the table to be re-created.

Seems there is an easy fix (if you know where to look), go to
Tools Menu >
Options >
Designers >
And untick the option “Prevent saving changes that require a table re-creation”

Entry Filed under: MS SQL. Tags: .

2 Comments Add your own

  • 1. Michael  |  July 5, 2009 at 8:16 pm

    Wow, thanx!

    Reply
  • 2. Werner  |  December 3, 2009 at 2:44 pm

    Thanks so much!

    And a biig biig biiig ShameOnYou to MicroSoft. Never seen such bull**** produced by a company with such a vast amount of developers (well actually their managers and designers are at fault) and such a vast amount of money..

    cheers!

    Reply

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

Archives

Recent comments

Blogroll

Top Rated

Top Clicks

Category Cloud

Advertising Brisbane SEO clickfind Business Directory ColdFusion Environmental initiatives Google Google Adwords Google Analytics In the media JavaScript JavaScript Form Validation Marketing MS SQL Other Programming Search Engine Optimization & Marketing Yahoo

Tags

alexa alexa ranking analytics anchor text links australia Australian Search Engines bartercard base bbx business directories business directory business directory review cfc clickfind ColdFusion confidence forum gadget Google hash html internet traffic keywords list local search markup MS SQL online marketing pagerank PR Programming RSS search engine search engines security SEO spellcheck spelling stored procedure tool trust tutorial validation website design www.mergermarket.com

Blog Stats

Top Posts

Authors