[Solved] An explicit value for the identity column in table 'Estate_sar' can only be specified when a column list is used and IDENTITY_INSERT is ON.

hi

I have 2 table in database

Estate_s and Estate_sar

both table have same column I want when users click on button according to id ,it insert all date from Estate_s into Estate_sar

below is SP

ALTER PROCEDURE [dbo].[editsave]
@Id int
,@Name_t nvarchar(40)
,@ContractN varchar(30)
,@ContractP varchar(30)
AS
BEGIN		
		UPDATE Estate_s
				SET
				Name_T=@Name_t
				,Contract=@ContractN
				,ContractP=@ContractP
				WHERE id=@Id

		INSERT INTO Estate_sar
		SELECT * FROM Estate_s
		WHERE id=@Id
END

but below error happen

An explicit value for the identity column in table 'Estate_sar' can only be specified when a column list is used and IDENTITY_INSERT is ON.

why this happen?

Best regards

Neda