title: Transaction log full when adding column to table
body: <p>I have a SQL Server 2008 table with approx 1.5 million records and I want to add another field and edit another.  When I save the changes it errors out:</p>
  
  <pre><code>'Member' table
  - Unable to modify table.  
  The transaction log for database 'storeboard' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
  </code></pre>
  
  <p>Even if I empty the transaction log it still does the same error.  How can I avoid this problem and make the necessary changes to my table?</p>