Saving Changes is Not Permitted

While making a database change that requires a table to be recreated, by default SQL Server Management Studio will not allow you to make the change.  Seems a bit strange that this is out-of-the-box behavior, but it’s easy to change:

Advertisement