code bits

code bits from my daily programming experiences in #c#,#sql,#.net,#asp.net,#hadoop,#PIG

Friday, June 21, 2013

Saving changes not permitted

If you try to use the SQL Server designer for making changes to the table you just created, then you will get a dialog box that tells you that you cannot save the changes.One work around this issue is to disable the option "Prevent saving changes that require the table to be re-created".

To disable this option see the screenshots below.
































































HTH
Posted by Virtuoso at 7:30 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ►  2016 (5)
    • ►  July (1)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2015 (20)
    • ►  December (2)
    • ►  November (1)
    • ►  October (2)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  June (3)
    • ►  May (4)
    • ►  March (2)
    • ►  January (1)
  • ►  2014 (21)
    • ►  December (4)
    • ►  November (3)
    • ►  October (5)
    • ►  August (1)
    • ►  July (2)
    • ►  June (1)
    • ►  April (5)
  • ▼  2013 (24)
    • ►  December (2)
    • ►  November (2)
    • ►  October (1)
    • ►  August (3)
    • ►  July (2)
    • ▼  June (1)
      • Saving changes not permitted
    • ►  May (1)
    • ►  April (1)
    • ►  March (6)
    • ►  February (1)
    • ►  January (4)
  • ►  2012 (61)
    • ►  November (7)
    • ►  October (3)
    • ►  September (2)
    • ►  August (12)
    • ►  July (36)
    • ►  June (1)
  • ►  2007 (5)
    • ►  September (3)
    • ►  June (2)
Simple theme. Powered by Blogger.