How do I disable the Table Designer timeout in SQL Server Management Studio?
Background
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: 9.00.1399.00
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 text
to nvarchar(max)
.
GO
statements (e.g. theEXEC('INSERT INTO dbo.Tmp_Transactions
fails, and then proceeds to drop the original withDROP TABLE dbo.Transactions
. i've only lost data once by manually running the generated scripts; i don't want that to happen again. That's why i prefer to do it from the designer, and not IN MANAGEMENT STUDIO. Loud noises. I DON'T KNOW WHAT WE'RE YELLING ABOUT.ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR(MAX) [NOT] NULL
sqlcmd
mode on the Query menu and addSET XACT_ABORT ON;
and:on error exit
to the top of the script;