How do I disable the Table Designer timeout in SQL Server Management Studio?
This KB Article seems to indicate that if you stop overriding the Designer timeout:
To resolve this behavior, use one of the following methods:
- Click to clear the Override connection string time-out value for table designer updates check box for the table designer and for the database designer in SQL Server Management Studio.
it is supposed to revert to the Execution timeout:
But rather than timing out never it times out after 30 seconds:
I've also tried setting the table designer to the maximum value of
65,535. Unfortunately that just causes the timeout to happen after 18 hours, rather than 30 seconds.
How do I disable the table designer timeout in SQL Server Management Studio?
SQL Server Management Studio:
Pre-emptive snarky comment: what kind of table change are you making that needs more than 18 hours to complete? I'm changing a column in a 130 GB table from