title: SQL Insert Failing - Violation of Primary Key Constraint
body: <p>I am seeing a very strange issue with a SQL Insert statement, I have a simple table, with an ID and 2 datetimes, see create script below -</p>
  
  <pre><code>CREATE TABLE [dbo].[DATA_POPULATION_LOGS](
      [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
      [START] [datetime] NOT NULL,
      [FINISH] [datetime] NOT NULL,
   CONSTRAINT [PK__DATA_POP__3214EC2705D8E0BE] PRIMARY KEY CLUSTERED 
  (
      [ID] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  
  <p>I am now trying to run the following insert script -</p>
  
  <pre><code>INSERT INTO [dbo].[DATA_POPULATION_LOGS]
             ([START]
             ,[FINISH])
       VALUES
             (GETDATE()
             ,GETDATE())
  </code></pre>
  
  <p>It is failing with the following error -</p>
  
  <pre><code>Msg 2627, Level 14, State 1, Line 1
  Violation of PRIMARY KEY constraint 'PK__DATA_POP__3214EC2705D8E0BE'. Cannot insert duplicate key in object 'dbo.DATA_POPULATION_LOGS'. The duplicate key value is (11).
  </code></pre>
  
  <p>The duplicate key value in the error message above increases every time the insert is executed, so it seems to know it is an identity column.</p>
  
  <p>What would be causing this issue?!</p>
  
  <p>Thanks in advance.
  Simon</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I have now created a copy of this table and can insert into the new table fine using that script, what could be causing it to fail?</p>