By default, when you make changes to a table using the SQL Management Studio GUI, it doesn’t allow to save the changes and it prompts you to save a test file. On the other hand if you make the same change using T-SQL commands you have no problems.
To remove this prohibition you must go to Tools and then click Options, at the SQL management studio menu bar. At the options window go to Designers and uncheck “prevent saving changes that require table re-creation” option and click OK
Pantelis Apostolidis is a Cloud Solutions Architect at Microsoft and an ex Microsoft Azure MVP. For the last 15 years, Pantelis has been involved to major cloud projects in Greece and abroad, helping companies to adopt and deploy cloud technologies, driving business value. He is entitled to a lot of Microsoft Expert Certifications, demonstrating his proven experience in delivering high quality solutions. He is an author, blogger and he is acting as a spokesperson for conferences, workshops and webinars. He is also an active member of several communities as a moderator in azureheads.gr and autoexec.gr. Follow him on Twitter @papostolidis.