Save Changes in a Table through Design View in SQL Server 2008

Hello Friends, hope you all are doing great. Yesterday I encountered a problem while working in Microsoft SQL Server 2008. I want to make changes in existing table through design view but when I press Ctrl+S, instead of saving the changes a window appeared showing the options to save the script. 

No need to worry, by following simple steps you can save changes through design view. 

Go to  

• Tools
• select Options 
• select Designers 
• select Table and Database Designers 

 Here you will find an option prevent saving changes that require table re-creation, Uncheck this option. 

And now you can save changes in your table through design view by pressing ctrl+s. Cheers

 

First Blog Post

Finally I am posting my first blog. It was not an easy task for me to choose the blog name. It seems very true that choosing a name for your blog is just like choosing a name for a new born baby LOL .
I had a plan to start blogging since long but couldn't do that. I will be sharing my everyday learning and experiences in this blog on daily basis.