21 reputation
113
bio website
location
age
visits member for 2 years, 9 months
seen Feb 9 '12 at 19:11

Oct
9
awarded  Famous Question
Jan
10
awarded  Notable Question
Jul
2
awarded  Popular Question
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 2348 characters in body
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 2348 characters in body
Feb
3
comment Why does simple ALTER TABLE command take so long on table with full-text index?
As per Jason's answer below, I issued the following update instead: ALTER TABLE RespondentData ADD NumericValue bit NULL; GO This finally did execute, but took 29 minutes, 16 seconds!
Feb
3
awarded  Student
Feb
3
comment Why does simple ALTER TABLE command take so long on table with full-text index?
Yes. The results were the same (script runs indefinitely until I cancelled it).
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 22 characters in body
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 1571 characters in body
Feb
3
awarded  Editor
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 952 characters in body
Feb
3
asked Why does simple ALTER TABLE command take so long on table with full-text index?