Warnings were encountered during the pre-save validation process

Asked By 30 points N/A Posted on -
qa-featured

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

Microsoft SQL Server

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

SHARE
Best Answer by Robert F McMiller
Answered By 10 points N/A #174349

Warnings were encountered during the pre-save validation process

qa-featured

Hello,

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

http://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:

http://www.wallaceit.co.uk/microsoft-sql-server/ms-sql-management-studio—save-changes-is-not-permitted/181/article.aspx

Hope that helps!

Best Answer
Best Answer
Answered By 0 points N/A #174350

Warnings were encountered during the pre-save validation process

qa-featured

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.

Login/Register to Answer

Related Questions