lo hice asi, pero me aparese un error gigante
CREATE TRIGGER historial_usuario
on tbl_usuario
for INSERT,DELETE,UPDATE
AS
BEGIN
Select @usu_pri_cod = (Select usu_pri_codigo From Inserted )
select @usu_nombre=(select usu_nombre from Inserted)
Select @usu_apellido = (Select usu_apellido From Inserted )
select @usu_cargo=(select usu_cargo from Inserted)
Select @us

sername = (Select us

sername From Inserted )
select @usu_password=(select usu_password from Inserted)
select @usu_email=(select usu_email from Inserted)
select @fecha=(select sysdate from Inserted)
INSERT INTO tbl_hist_usuario(hist_usu_priv_det,hist_usu_nombre ,hist_usu_apellido,hist_usu_cargo,hist_us

sernam e,hist_usu_password,hist_usu_email,hst_usu_fecha)
values( @pri_detalle,@usu_nombre,@usu_apellido,@usu_cargo, @us

sername,@usu_password,@usu_email,@fecha);
END