title: SQL Server table gets re-created, losing historical data
body: <p>I have a SQL Server table that keeps getting re-created, due to which history data gets lost.</p>
  
  <p>I am unable to track what is causing this table to re-create.</p>
  
  <p>I have created a trigger, and also went through SQL Server event logs but found nothing that indicates the cause for the re-creation of this table.</p>
  
  <p>Please suggest a solution how to identify the cause of the table re-creation and steps to prevent it from happening.</p>