Saving Changes Is Not Permitted On SQL Server 2008. How To Solve?


Saving changes is not permitted occurs when doing alter table (table structure is changed):

  1. change data type on existing columns
  2. or change allow nulls on existing columns

To allow you to save changes after you alter table, do disable prevent changes:

  1. Open Microsoft SQL Server Management Studio 2008
  2. Click Tools, then click Options
  3. Click Designers
  4. Uncheck prevent saving changes that require table re-creation
  5. Click OK
  6. Try to alter your table

 

Hope this would be helpful.:)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s