BKStart a conversation ↗

Data & Persistence

SQL Server 2008 Prevent Saving changes

1 min read

When you modify a table in SQL Server and this change requires the table to be dropped and recreated, it’s necessary that SSMS is configured to allow this.

Go to SSMS/Tools/Options designers and uncheck this option.

See below.