Skip to main content

SQL Management Studio - "Saving changes is not permitted ..." error

Sometimes when you are working something using SQL Management Studio (SSMS) and intend to make changes to existing table schema, e.g. adding a new column, you may encounter the following error message. You are unable to proceed making the changes you desire with SSMS user interface.

Saving changes is not permitted ...

So what can you do? Either you re-create the table or write ALTER statements (but let's not do that!).

There is, however, a known trick to get around the above annoying "Saving changes is not permitted ..." error. Here are the steps to do just that!
  1. From the SSMS, go to Tools > Options.
  2. Select the Designers page.
  3. Un-check "Prevent saving changes that require table re-creation".
    Options Box
  4. Click OK button.

You should be good to go now!

Popular Posts

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.

手牵手,加油日本!

Google Suggestion "where is" - Najib, Rosmah - Malaysia GE17

The 14th Malaysian general election held on 9 May 2018 had concluded with the incumbent Barison Nasional (BN) voted out and Najib losing his Prime Minister position. Taking over the government is the opposition party with Dr Tun Mahathir Mohamad, a former Prime Minister of Malaysia, being sworn in as the 7th Prime Minister. Dr Mahathir is now 92 years old.

So where exactly is Najib and his wife Rosmah? Even Google is showing the below when I type "where is". I bet many people are now searching for this.