>I put a 20 seconds pause after the Update. Here is what it gives:
>
>-------------------
>Adding MyTable.FaxPhone-Temporary...
>Updating MyTable.FaxPhone-Temporary...
>
>(1838535 row(s) affected)
>Waiting for 20 seconds...
>Droping column MyTable.FaxPhone...
>ALTER TABLE DROP COLUMN FaxPhone failed because one or more objects access this column.
>-------------------
>
>I have to say I am beginning to run out of solutions. I tried a lot of things and something is causing this behavior which I cannot explain.
Let me ask my friend Peter Larsson to check this thread.
If it's not broken, fix it until it is.
My Blog