Want to make changes to the database table in Microsoft SQL Management Studio, but getting the following message "Saving changes is not permitted" (figure 1)
Step 1: Go to Tools, and click on Options. The following screen gets displayed.
Step 2: Click on Designers => Table and Database Designers (highlighted above).
Step 3: Unchecke "Prevent saving changes that require table re-creation" and click on 'OK'
Note: You may also unchecked 'Warn about tables affected'. If this is checked you will see the following message.
Click on OK.
All the requested changes are saved. Done!!
Comments
Post a Comment