>

>
>INSERT INTO AlertImport
>		(Active,
>		ExpiredDate,
>		ContractNo,
>		SystemId,
>		ItemNumber,
>		Description,
>		Price,
>		ContractSeverityCode,
>		EquipmentSerialNumber,
>		LineType,
>		AddressCode)
>	SELECT Active,
>		   ExpiredDate,
>		   ContractNo,
>		   SystemId,
>		   ItemNumber,
>		   Description,
>		   Price,
>		   ContractSeverityCode,
>		   EquipmentSerialNumber,
>		   LineType,
>		   AddressCode
>	FROM AlertImport
>

If identity is the first field, you don't have to specify all fields.

You also could have simply ALTER the table to add identity column. I thought of this, but needed to be interrupted for something, so could not test right away.