SQL Server force identity insert for autoseed pk

  use InspectionManager
  GO
  set identity_insert dbo.report ON 
  go
  insert into Report(ReportID, InspectionID, Name, DateCreated) values(124842,161815, 'wa report', '2013-07-01 20:59:09.297')
  set identity_insert report OFF
  go