I am converting an Oracle DB into a SQL DB, and I am trying to modify some of the characteristics in SQL Server (data type, index, etc.), but when I try to make a change (table design window) it tells me"
"Saving changes is not permitted. The changes you have made require the table to be dropped and re-created. You have either made changes to a table that can't be re-created, or enabled the option Prevent saving changes that require the table to be re-created."
There is no reason that the table should not be able to be re-created, and I don't seem to be able to find the option "Prevent" that would keep it from happening.
All help is appreciated!
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.