title: Change Table Structure in SQl Server 2008
body: <p>I am trying to change a design of a table in SQL Server 2008, but I am getting an error stating that I need to drop and recreate the table.How Can I Solve This Problem.</p>
  
  <blockquote>
    <p>Saving Changes is Not Permitted.The
    Changes you Have Made require the
    following tables to be dropped and
    re-created.you have either made
    changes to a table that can't be
    re-created or enabled the option
    prevent saving changes that require
    the table to be re-created.</p>
  </blockquote>