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
No comments:
Post a Comment