Sql 2008 Management Tools: Can't save changes that require Recreation of Database

Tras instalarme SQL Server 2008, he creado una base de datos y una tabla. Poco después he tenido que modificar esa tabla, pero al intentar guardarla me he encontrado con un error:


"Saving changes is 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 re-created or enabled the option Prevent saving changes that require the table to be re-created."

Tras investigar un poco he encontrado la solución:

En SQL Server Management Studio, vamos a Tools -> Options, y en la pestaña Designers -> Table and Database Designers, desactivamos la opción Prevent saving changes that require table re-creation.




Espero que os sirva.

Sql 2008 Management Tools: Can't save changes that require Recreation of Database Sql 2008 Management Tools: Can't save changes that require Recreation of Database Reviewed by Ricardo Castellanos on 13:11 Rating: 5

No hay comentarios:

Con la tecnología de Blogger.