Skip to content

Saving Table Changes in the Design Option

December 2, 2009

Problem: You have just modified a table in the Design Option in SQL Server 2008 Management Studio but it will not allow you to save the changes you made. You are getting an error that says:

“saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created…”

You can find the *solution* in this post by Tim Edwards (Twitter | Blog). I have encountered this issue few times and I thought it was an issue in SSIS or something (I was modifying lots of target tables). If I read Tim’s post on this prior to when I was having this issue, I should have saved a handful of time.

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

  • Archives


  • RSS SQLServerPedia

  • RSS SQL Crunch – Hot SQL Links

  • My Bookmarks

  • Business Career DBA Tool Events free ebook Humor IT News Members Only Microsoft MySQL Operating System Oracle Personal Reporting Services SQL Server SQLServerPedia Syndication SSC SSIS TSQL Tutorial Uncategorized Video

  • Software Blogs - BlogCatalog Blog Directory
  • %d bloggers like this: