| layout | status | title | slug |
|---|---|---|---|
post |
publish |
Dear Sql management studio, just let me save my database table!! |
Dear-Sql-management-studio-just-let-me-save-my-database-table- |
If you're like me, you recently upgraded to Sql Server 2008 (or just installed the Management Studio). If you're really like me you found the "Saving changes is not permitted" dialog that pops up every time you try to save a modified table annoying.
You may not have found it annoying enough to investigate but I sure did. I don't remember Management Studio 2005 complaining when I changed a table and saved it. Why the change in 2008?
Well, anyway, here's your chance to get rid of that dialog once and for all.
In Sql Management Studio, go to Tools -> Options, expand down the Designers node, and select Table and Database Designers. In the Table Options section uncheck Prevent saving changes that require table re-creation and you're done!
You can now change your database tables hassle free!