SQL Server 2008 – Saving changes is not permitted
Apr.21, 2009 in
Business Intelligence, SQLServerPedia Syndication
Finally getting around to doing some work on SQL 2008, and after about 3 minutes, I run into this error: “Saving Changes is not permitted.. blah blah blah” See screenshot below.
This is different than SQL 2005. Microsoft maybe trying to save us from ourselves? The thing is, I never “enabled the option Prevent saving changes that require the table to be re-created” – it seems to be enabled by default. It would be awesome if this error told me exactly where the setting was.
Well, it happes to be in Tools->Options, Designers, Table and Database Designers. Uncheck the box and go about your merry way!
Simlar Posts
- SSIS – Pulling Data from a non default collation DB to a default collation DB
- Office 2010: Excel 2010, What-If Analysis aka Microsoft Finally has Built in Cube/OLAP Writeback!
- SQL Server 2005 Reporting Services – Fix Slow Loading On First Report Load
- Microsoft BI Client Tools: Easing the Transition from Excel 2003 to Excel 2007 – PivotTable Layout and Design
- SQL Server Management Studio and Excel – Column Headings on Copy/Paste