SQL Server Management Studio Tips - How to activate saving table modifications

June 28, 2013 less than 1 minute read

Once you have created a table using Sql Server Management Studio, you have done changes the table structure, you want to save it.

But SSMS doesn’t allow you to do so.

You need to modify the configuration in Tools -> Options -> Designers and uncheck “Prevent saving changes that require table re-creation”.

I hope this post can do help to you!

SUN Jiangong

A senior .NET engineer, software craftsman. Passionate about new technologies.

Recent posts

Microsoft .NET challenge France 2022 final

2 minute read

How to monitor azure event hub events in real-time?

1 minute read

How to maintain legacy applications?

less than 1 minute read

What are Azure TenantId, ClientId (Application Id) and ObjectId?

2 minute read

types/uuid - Uncaught TypeError Object(...) is not a function

less than 1 minute read

Which tools you need to develop web applications in ReactJS?

2 minute read

An optimized version of function sys.fn_cdc_is_bit_set

less than 1 minute read

Microsoft .NET challenge France 2020 final

3 minute read

How to create integration tests with Entity Framework (EF) core?

2 minute read

How to upload and download file in Angular 5+ and .net core

2 minute read

MS SQL server full-text index reserved words

6 minute read

How to create unit tests on internal methods and protected methods in .net core?

2 minute read