When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes.
This is caused by a configuration setting that default results in the following dialog:
Error Screen
Solutions:
This is by design and can be quickly fixed in Management Studio by unchecking a property.
To fix this in Management Studio, go to Tools -> Options then go to the Designer Page and uncheck "Prevent saving changes that require table re-creation
3 comments:
Hari:In Sql Server 2008,a sql query is generated.If We delete a row data in sql server and we entered the design of that table.We can save changes in sql server 2008
http://www.theosoftindia.com/
It's so nice article thank you for sharing a valuable content. SQL server dba Online Training Bangalore
We at COEPD provides finest Data Science and R-Language courses in Hyderabad. Your search to learn Data Science ends here at COEPD. Here, we are an established training institute who have trained more than 10,000 participants in all streams. We will help you to convert your passion to learn into an enriched learning process. We will accelerate your career in data science by mastering concepts of Data Management, Statistics, Machine Learning and Big Data.
https://www.coepd.com/AnalyticsTraining.html
Post a Comment