martes, 15 de marzo de 2022

Error de SQL Server Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created.


Problema

Cuando uno trata de editar una tabla en SQL Server de manera visual usando la opción de designer recibe el siguiente error.

Saving changes is not permitted. The changes that 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.


Por defecto, SQL Server no permite cambios que requieran borrar y recrear la tabla. Para solucionar el error, debe habilitar la siguiente opción en SQL Server.

Solución 


Vaya a Tools>Options y remueva la opción Prevent saving changes thar require table re-creation



People who read this post also read :



No hay comentarios:

Publicar un comentario