title: SQL Azure raise 40197 error (level 20, state 4, code 9002)
body: <p>I have a table in a SQL Azure DB (s1, 250Gb limit) with 47.000.000 records (total 3.5Gb). I tried to add a new calculated column, but after 1 hour of script execution, I get: <strong>The service has encountered an error processing your request. Please try again. Error code 9002</strong> After several tries, I get the same result.</p>
  
  <p>Script for simple table:</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>Script for alter:</p>
  
  <pre><code>alter table user_works add delta_secs as datediff(second, start_time, end_time) PERSISTED
  </code></pre>
  
  <p>Error message:</p>
  
  <pre><code>9002 sql server (local) - error growing transactions log file.
  </code></pre>
  
  <p>But in Azure I can not manage this param.</p>
  
  <p>How can I change my structure in populated tables?</p>