Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation

by

From Save (Not Permitted) Dialog Box on MSDN :

The Save (Not Permitted) dialog box warns you that saving changes is
not permitted because the changes you have made require the listed
tables to be dropped and re-created.

The following actions might require a table to be re-created:

  • Adding a new column to the middle of the table
  • Dropping a column
  • Changing column nullability
  • Changing the order of the columns
  • Changing the data type of a column <<<<

To change this option, on the Tools menu, click Options, expand
Designers, and then click Table and Database Designers.
Select or clear the Prevent saving changes that require the table to be
re-created check box.

See Also
Colt Kwong Blog Entry:
Saving changes is not permitted in SQL 2008 Management Studio

More Related Contents:

  1. How to connect to local instance of SQL Server 2008 Express
  2. sql server 2008 management studio not checking the syntax of my query
  3. SQL group_concat function in SQL Server [duplicate]
  4. Pivot Dynamic Columns, no Aggregation
  5. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  6. varchar(max) everywhere?
  7. T-SQL: Export to new Excel file
  8. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  9. SQL Server 2008: how do I grant privileges to a username?
  10. sql runs fast in ssms slow in asp.net
  11. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  12. How to get the last record per group in SQL
  13. How to convert float to varchar in SQL Server
  14. Query times out when executed from web, but super-fast when executed from SSMS
  15. How can I load a large flat file into a database table using SSIS?
  16. Unique constraint on multiple columns
  17. How to convert datetime in Persian in SQL Server
  18. How to restore to a different database in SQL Server?
  19. Why is SQL Server 2008 Management Studio Intellisense not working?
  20. Reporting Services permissions on SQL Server R2 SSRS
  21. T-SQL substring – separating first and last name
  22. SQL Server: Split operation
  23. How to implement polymorphic associations in an existing database
  24. How to deploy SQL Server Compact Edition 4.0?
  25. Converting Select results into Insert script – SQL Server
  26. What is the default transaction isolation level for SQL Server with ADO.NET?
  27. Restrict SQL Server Login access to only one database
  28. T-SQL strip all non-alpha and non-numeric characters
  29. Avoiding IF ELSE due to variable been NULL
  30. Where are SQL Server connection attempts logged?

Leave a Comment