Article ID: 915849 - View products that this article applies to.
When you try to modify a large table by using the table designer in Microsoft SQL Server Management Studio, you may receive an error message that is similar to the following:
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This behavior occurs because of the transaction time-out setting for the table designer and for the database designer in SQL Server Management Studio. You can specify this setting in the Transaction time-out after box. By default, this setting is 30 seconds.
Notice that this setting differs from the setting in the Execution time-out box in SQL Server Management Studio. By default, the setting in the Execution time-out box for Query Editor in SQL Server Management Studio is zero. By default, the setting in the Query time-out (seconds) box for Query Editor in Microsoft SQL Server 2000 SQL Query Analyzer is also zero. Therefore, Query Editor waits infinitely for the query to finish and never times out.
To resolve this behavior, use one of the following methods:
The modification of a large table may be time-consuming. This is because SQL Server must perform the following actions when you try to modify the table schema:
Article ID: 915849 - Last Review: March 31, 2006 - Revision: 1.1
Contact us for more help
Connect with Answer Desk for expert help.