Edit table in SQL 2008

[holtis]

Hello all,

Im currently developing a project on the 2008 server.
Im having some problems while working with the tables.

Creating and saving a new table (via SMS) it works well BUT when ever i try edit a table I get an error message like this:

"Saving changed is not permitted. The changes you have made require the following table to be dropped and re-created. You have either made change to a table that can't be changed or enabled the option prevent saving changes that require the table to be re-created"

This is quite annoying while developing a database, this worked with out any problems in 2005/2000.

Thanks

holtis

[holtis]

I solved the problem by following this link:
http://technet.microsoft.com/en-us/l...(SQL.100).aspx

Thanks

[rmiao]

Keep in mind that sql2k8 is not official release, possible to get any silly problem.