I've got a table of more than 400 million rows and want to convert the datatype of one of its columns, specifically
If I execute my statement, I get the following error:
The transaction log for database 'xxxx' is full due to 'ACTIVE_TRANSACTION'
So is here any possibility to update this table?
(My log file can have a maximum size of 150GB, I don't have any more free space available.)