Wednesday, July 29, 2009

Prevented from saving changes when changing database schema in SQL Server 2008




Although this option is automatically enabled by default for probably good reason, if this option is getting in your way, then you can disable it. It's simple:

  1. in management studio, go to Tools -> Options


  2. Then in Designers, uncheck the option "Prevent saving changes..."

No comments:

Post a Comment