I am trying to alter a field in tableA from 2 char to 3 char, in a table with over 135,000,000 records.
When running script below, it runs for 35-40 minutes and stops saying no more room or just disconnects my job.
I assume it stops because of all the records it has to alter.
I have no control over servers. Just wondering if there is a better way.
alter table tablea alter column [rt_code] char(3)
The next thing I will try is:
copying tablea to tablea_bk
deleting all records in tablea
then alter tablea
then copy records back to tablea from tablea_bk