SQLServer2008

Changes to table that can't be re-created/enabled option Prevent saving changes

Annoying SQL Server 2008 message. Saving 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't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

To fix this annoying crappy message, follow these instructions:

Within SQL Management Studio click on the Tools menu. Then Options, then the Designer node and uncheck the box that says: Prevent saving changes that require the table to be re-created.

Alternate Solution if This Fails

MS SQL Server Management Studio 2008: Error 916 Solution here

Problem with MS SQL Server Management Studio 2008 connecting & managing databases on my shared host’s SQL Server 2005.

I couldn’t access my database, as I clicked the “Database” node within “Object Explorer” I received the message:

The server principal “username” is not able to access the database “dbName” under the current security context. (Microsoft SQL Server, Error: 916)

The dbName that said I didn't have permissions to was the first database in the list.  Bummer, expecially when I'm in a hurry to get something done and now time to research.  So I found the work around.

Solution to Microsoft SQL Server Error: 916

  1. In Object Explorer of your remote connection, click Databases
  2. Click “View / Object Explorer Details” in menu
  3. Right click the column headers and deselect “collation”
  4. Refresh the entire connection or maybe just the Databases

This works for me.  Thanks, Tom Hall.