I have the following trigger but the table the Insert is not being performed on the tblEMSHistory. The field I changed in tblEmpInfo was changed. ANy suggestions on what I need to modify
CREATE TRIGGER trgEdit ON tblEmpInfo
IF (COLUMNS_UPDATED() & 14) > 0
-- Audit OLD record.
INSERT INTO tblEMSHistory
( EmpID, empStatus ,Supervisor, Department ,Location)
del.EMpID, del.empStatus, del.Supervisor, del.Department, del.Location
FROM deleted del