sql server - SQL Azure raise 40197 error (level 20, state 4, code 9002) -

i have table in sql azure db (s1, 250gb limit) 47.000.000 records (total 3.5gb). tried add new calculated column, after 1 hour of script execution, get: the service has encountered error processing request. please try again. error code 9002 after several tries, same result.

script simple table:

create table dbo.works (     work_id int not null identity(1,1) constraint pk_works primary key,      client_id int null constraint fk_user_works_clients2 references dbo.clients(client_id),     login_id int not null constraint fk_user_works_logins2 references dbo.logins(login_id),     start_time datetime not null,     end_time datetime not null,     caption varchar(1000) null) 

script alter:

alter table user_works add delta_secs datediff(second, start_time, end_time) persisted 

error message:

9002 sql server (local) - error growing transactions log file. 

but in azure can not manage param.

how can change structure in populated tables?

azure sql database has 2gb transaction size limit running into. schema changes yours can create new table new schema , copy data in batches new table.

that said limit has been removed in latest service version v12. might want consider upgrading avoid having implement workaround.