SQL Server 2008: “Saving changes is not permitted”

Working in SQL Server 2008 I received this confusing error when editing the structure of a table: “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 … Continue reading SQL Server 2008: “Saving changes is not permitted”

Advertisements

Truncating all tables in SQL Server database

  The script below can be used to truncate all the tables from the sql server database. -- Start of Script - Truncate_ALL_Tables.sql/*Find Table Reference LevelsThis script finds table references and ranks them by level in orderto be able to load tables with FK references in the correct order.Tables can then be loaded one level … Continue reading Truncating all tables in SQL Server database