In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and we want to change the datatype or adding any column in a table with SSMS (SQL Server Management Studio), and the SSMS will said to us that changes in the table are not allowed you should to recreate table insted of changing it!
Yes, this is the worry situation that you cannot wait or you have many things to do after that change etc etc. Considering that you have nice experience with data and table structures and to avoid this little restriction you should go to the SSMS Tools > Options > Designers | to uncheck the option "Preventing saving changes that require table re-creation".
That's it for the beginner users to avoid the restriction that prevent changing tables in SQL2k8/SQL2k5!
Have a nice SQLing!
