SQL Server 2008 was recently launched by Microsoft with the aim to make data management self-tuning and self-organizing. With the help of this improved version you can make your task much easier as it offers advanced tool for better database management. But occurrences of error message are quite common in all versions of SQL and similar problem occurs in SQL server 2008. In some cases you are unable to modify table in SQL server 2008. Most of the time it happens that when you attempt to save changes in SQL you receives below error message:

“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?”

Usually after getting above error message users click on “Yes” button in order to save the changes in any way. But while changes are being saved, table data will not be accessible. Users generally pauses the process of updating the table but after few seconds it shows another error messages indicating unable to modify table in SQL. The error message appears in following manner:

“Errors were encountered during the save process. Some database objects were not saved” and “Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”

Once you get above error message the changes which you have made to the table is not saved and it remains similar as before. If you are unable to modify table in SQL server 2008 then it seems that issue is caused due to timeout setting for “table designer updates” which is set to 30 seconds as default value. So, in such case table is not updated and saved within this time interval and you will be unable to modify table timeout expired.

In order to resolve this problem unable to modify table in SQL you need to change the timeout settings in following manner:

• Select Tools->Options->Designers
• After selecting it you will be shown screenshot which shows red box highlighting “Override connection string time-out value for table designer updates” and “Transaction time-out after”
• Set the default 30 seconds value to some higher value and then click OK

INow you can easily modify table and save the changes without any troubles.