Web Resources   >   Database   >   SQL Server 2008
October 31, 2014

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.

Services
Other Services
About Us
Location
Custom Software Applications
Database Programming
Web Development and Design

Search Engine Optimization
Report Writing
IT Consulting
MS Excel Consulting
MS Access Programming
FAQs
Contact
Request a Quote
Free SMS Pro Quote
Alaska Web Design Company
Email: chowell@nwds-ak.com
Phone: 907-227-1676
cash, check, credit card, invoice, paypal
2627 C Street
Anchorage, AK 99503