>I have restored a database into SQL Server 2008. I want to try using the new DATE type column. So I got into SSMS 2008,
went to one of the tables and tried to change the type that was SmallDateTime to Date. When attempting to save the
changes I get the following message:
>
>

>Saving changes in not permitted. The changes you have made require the following tables to be dropped and re-created.  You 
have either made changes to a table that can't be recreated or enabled the option to Prevent saving changes that require 
the table to be re-created.
>

>
>I have not enabled or disabled anything in the newly installed SQL Server 2008 Developer. So my question is where do I go
and undo this "Prevent" changes option?
>
>TIA


Dmitry,
using new features is good, but you will loose all clients that are not updated yet.
Not every company is upgraded its SQL Server to 2008.