ok :)
Código SQL:
Ver originalALTER TRIGGER [dbo].[deletehistorico] ON [dbo].[Presentes]
FOR DELETE
AS
BEGIN
INSERT INTO GestionAforo.dbo.EntradasSalidasMes
( FechayHoraSalida, Nombre, Apellidos, Empresa)
SELECT CURRENT_TIMESTAMP, DASS.dbo.Personas.Nombre, DASS.dbo.Personas.Apellidos, Dass.dbo.Empresas.Empresa FROM DASS.dbo.Personas, DASS.dbo.Empresas WHERE DASS.dbo.personas.id=(SELECT fkpersona FROM deleted) AND DASS.dbo.Empresas=(SELECT fkempresa FROM deleted)