Loading ...

SQL Server 2008: Saving Changes Is Not Permitted On SQL Server 2008 | CodeAsp.Net

SQL Server 2008: Saving Changes Is Not Permitted

 /5
0 (0votes)

While working with SQL Server 2008 R2 I was getting the following error:

"Saving Changes Is Not Permitted On SQL Server 2008"

I am writing the steps how you can fix it:

  1. Click Tools > Options
  2. Click "Designers" option
  3. Uncheck the checkbox sa prevent saving changes that require table re-creation
  4. Click OK


After doing the above steps your issue will be fixed.

Comments (no comments yet)

Top Posts