Toad World® Forums

ToadSS hangs when alter table fails


#1

Here is a circumstance where ToadSS 5 hangs.

Alter a table and remove a column that is referenced in a trigger and click ok.
The process will run for a few seconds then come back with an error. Click okay
again and ToadSS will stop responding. I have reproduced this but have not tried
other situation that might cause an alter table to fail.

Tim


#2

More information on this. It doesn’t hang after all. I had another case of an
alter table that failed but walked away from it and it eventually timed out and
generated an error, but it was at least 10 minutes later before it did. Also, it
happens with any invalid alter, like creating a new not null column without a
default.

Tim