Saving changes is not permitted error in Sql Server

Published: 03 June 2019
on channel: SSIS Assistance
17
1

You may get an error when trying to change a data type of a column on a table in Sql Server:

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.

I demonstrate a way to fix that issue by changing the settings.

More can be read on this issue here: https://support.microsoft.com/en-us/h...


On this page of the site you can watch the video online Saving changes is not permitted error in Sql Server with a duration of hours minute second in good quality, which was uploaded by the user SSIS Assistance 03 June 2019, share the link with friends and acquaintances, this video has already been watched 17 times on youtube and it was liked by 1 viewers. Enjoy your viewing!