SQL 2008 - Can't save changes to table

25. February 2009

One change they have made to SQL 2008 was really bugging me. If you would change a table in the SQL Server Management, you would get an error message:

Error
Click for larger view

That is frustrating so I took to searching for a fix.

Click on Tools - Options - and on the Designers node, you will find a check box "Prevent saving changes that require table re-creation"

Options

After that, you should be able to make all of the changes you wish.

Currently rated 4.0 by 1 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SQL

Trek 412

6. February 2009


My first 'real' bike way back in '81

Trek 412

Click for larger view

But that was followed a year later with a Ciocc

Ciocc

 

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Cycling