Recently, I installed the new build in of Sql Server 2008 R2. Using the Management Studio, I created and saved a Table in the Design View. Later on, I added a couple of columns to the same Table and hit the Save button. Phew…!!! I’m bombarded with this surprising warning message.
Saving changes is not permitted. The changes 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 changes that require the table to be re-created.
A sample screenshot looks like,
I’s wondering what the changes have been made to the Sql Server 2008 Table Designer bits as compared to the Sql Server 2005 bits Table Designer. Because, you won’t get any such warning in Sql Server 2005 Table Designer.
However, You can fix this warning dialog box by disabling the option the ‘Prevent saving changes that require the table to be re-created’.
Here is the Exact step to enable it:
Start Sql Server Management Studio
Menu: Tools –> Options
From the left-side Tree: choose Designers –> (uncheck) Prevent saving changes that require the table to be re-created
Hope this helped. Thanks.
Does anyone noticed this. Facebook has an Easter-Egg within it. The comment section of the Facebook has a watermark as -
, which gets automatically cleared on selecting the comment-area.
Ever guessed what’ll you get when you type the same Write Comment… as a comment?
The result will be:
Cool. Isn’t it?
It’s been 24 Hours after IE9 Beta starts “Beautifying The Web”. So far, no gossips have been heard; expect from some Anti-IE Groups.
Already enough reviews are flooding all around, so I’m not taking time to write a review. All I can say is:
She’s an Amazing Piece of An Art
Cute, Awesome, Ambitious, Soft and Sexy
Really, She’s gonna be - “The Beauty of The Web”
Download IE9 Beta and you’ll Love it. :)