I am using Server 2008 Management Studio to interact with an SQL 2008 Server.
When I create then save a table, if I go back to make a change to a field it almost always errors out when I try to save. I cannot even Delete the column, and make a new column without saving in between; if I try to do both without saving in between I get an error.
If I try to change the datatype after saving, it will not save the change.
I cannot change the Identity property after the column has been created.
The database was from an SQL 2000 Server; however, the tables am working with are newly created.
Any idea what the source of my problems are and how to fix it so I can save?