I don't think so. What is the elevated priviedges? I have administrator rights.
By the why I found a blog with a partial solution.
http://weblogs.asp.net/atlaszhu/archive/2010/04/04/sql-server-2008-database-diagram-quot-saving-changes-is-not-permitted-quot.aspxBut if i understand it correctly, it just allows SQL to re-create the table from the Database Diagram. So, if there is any data, it is probably history.
>Were you running with elevated privledges? You'll need it to do some things in SQL Server.
>
>>I have been learning SQL 2008. After creating a few related tables, I added a few additional column to one of the tables. When I attempt to save the table structure I get an error telling me that the table can not be dropped and re-created.
>>
>>1. Why when added a new column does SQL need to drop the original and re-create it?
>>
>>2. If the constraint are the problem, why doesn't SQL drop the constraints and recreate them?
Greg Reichert