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 transac