title: Force default value when adding column to table - SQL Server
body: <p>In SQL Server 2000/2005,</p>
  
  <p>Is it possible to force the default value to be written to already existing rows when adding a new column to a table <strong>without</strong> using NOT NULL on the new column?</p>