Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Exploring SSMS - Enabling Save changes

Jun 6 2011 2:23AM by Madhivanan   

SQL Server Management Studio (SSMS) is the powerful tool for any developer/DBA to intereact with the SQL Server. It has lot of features that many people do not aware of. In this series of blog posts I am going to show you some features which are very helpful and not known by many people.

While modifying the structure of the table in SSMS, you might have had the problem which resulted to the following error message

Save changes is not permitted. The changes you have made require the following tables to be dropped or re-created. You have either made the changes to a table that can't be re-created or enabled the option Prevent saving chages that require the table to be re-created.

To avoid this error follow these steps, in the toolbar, goto

Tools-->Options-->Designers-->Table and Database designers

and uncheck the option labelled Prevent saving changes that require the table to be re-created

Now you will be able to make changes in the table design in SSMS

Tags: t-sql, sql_server, sqlserver, tsql, BRH, SSMS, savechanges,

2 · 40% · 13039
1 Readers Learned from this post
Adam Tokarski Learned from this post on 4/2/2012 7:05:00 AM



  • Nice! Good one to Share with Beginners. Did encounter this issue when i first started

    commented on Jun 20 2011 5:49AM
    538 · 0% · 70
  • Nice one, i never came across this.

    commented on Jun 20 2011 9:09PM
    3162 · 0% · 2
  • I recommend disabling this on a test/development server only, once you are done with the development then enable it again. This is checked off to preserve the data integrity of the tables.

    commented on Jun 28 2011 11:40AM
    Database Diva
    3162 · 0% · 2

Your Comment

Sign Up or Login to post a comment.

"Exploring SSMS - Enabling Save changes" rated 5 out of 5 by 6 readers
Exploring SSMS - Enabling Save changes , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]