Errors were encountered during the save process.

Asked By Dominic D Beaton 20 points N/A Posted on - 03/08/2013

I was trying to save my existing table but when I click to save an error message suddenly appears which you can see in the below attached image. Any idea? I need the assistance of anyone.

Post-save Notifications

Errors were encountered during the save process. Some data objects were not saved.

Unable to create index

Timeout expired. The timeout period elapsed prior to completion of the operation or the Could not create constraint. See previous errors.

 

• Status: Open
• Question Views: 6040
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Joshua Y Roush 0 points N/A #173615

Errors were encountered during the save process.

Hi Dominic D Beaton,

Well this problem occurs due to default saving changes to the table that required table re-creation which is disabled.

You need to enable this option to allow save changes to table re-creation.

You need to follow some simple steps.

• Open the MYSql Server Management Studio.
• Click on the tool tabs after click on the Options.

• A new window will open and on the left side click on the Designers option.

• Now on the right side “Table Option” screen will be displayed.
• Check the last option in Table Option section and then click ok.

• After saving these settings you problem will definitely solve, Best of Luck.

Regards,

Joshua Y Roush

About Joshua Y Roush

Questions
5

Answers
9

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 03/13/2013
• Question Category: Database