Warnings were encountered during the pre-save validation process

Asked By Tony S Boudreau 30 points N/A Posted on - 03/08/2013

I am getting a validation warning while I am trying to modify a table in Microsoft SQL Server. I am unable to modify please help me. Thanks

Validation Warnings

Warnings were encountered during the pre-save validation process, and might result in a failure during save. Do you want to continue attempting to save?

'Employee' table

– Warning: One or more existing columns have ANSI_PADDING 'off' and will be re-cr

Yes No Save Text File

• Status: Open
• Question Views: 6620
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Database

Best Answer by Robert F McMiller

Go To Solution

Answered By Matthew B Brown 10 points N/A #174349

Warnings were encountered during the pre-save validation process

Hello,

A step by step procedure to solve your issue is given in the following link:

https://www.electrictoolbox.com/unable-modify-table-timeout-expired-sql-server/

Also, this link has a number of screen shots to guide you in understanding the solution.

Alternatively you could use the followng link:

https://rsw.tv

Hope that helps!

About Matthew B Brown

Questions
7

Answers
35

Best Answers
12

• Vote Up 0 Vote Down

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

Best Answer

Best Answer

Answered By Robert F McMiller 0 points N/A #174350

Warnings were encountered during the pre-save validation process

After seeing this error message, the user naturally clicks "Yes" button as he does not want to save the changes. After 30 seconds, you will see another error message just like in the following screenshot.

This problem is mainly caused by a timeout setting for "table designer updates" that is set to 30 seconds as default. To change the settings, simply go to Tools>>Options>>Designers. Follow the screenshot.

Change the default 30 seconds value to some higher value, click "OK" and run your table structure again.

About Robert F McMiller

Questions
9

Answers
30

Best Answers
8

• Vote Up 0 Vote Down

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