use heredia
go
SET IDENTITY_INSERT [operacoes_desconto] ON

INSERT INTO operacoes_desconto (cd_oper,cd_pes_funcio,cd_tp_desconto,cd_login,registro) 
    SELECT cd_desconto,cd_pes_funcio,cd_tp_desconto,cd_login, registro  FROM desconto 
GO 


SET IDENTITY_INSERT [operacoes_desconto] Off