>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.aspx
>

No, I think you understood incorrectly. Using this option will use ALTER TABLE script instead.

In other words, I think your data will be preserved. Although since you're in the beginning stage, it may be a good idea to try and tell us to be sure.

BTW, I planned to suggest this option to you as well but got distracted...

Check this related link http://tek-tips.com/viewthread.cfm?qid=1548439&page=2