SQL SERVER cannot modify the table structure or column type.
When using table structure design in SQL SERVER:
Note: you cannot save the changes. You must delete and recreate the following tables. You have made changes to tags that cannot be re-created or enabled the "change to prevent table re-creation after saving" option.
Solution:
Start mssql server 2008 and choose menu tool> Options> designer> Table Designer and database designer on the left. Then, remove the check box before "Preventing table creation changes due to saving. Restart mssql server 2008. As shown in:
Copyright Disclaimer: Author: jiankunking Source: http://blog.csdn.net/jiankunking this article copyright to the author and CSDN a total, welcome to reprint, but without the author's consent must retain this statement, and in the Article Page clearly given the original connection.