thank you for your answer and your time. i really appreciate it .

i tried it like this

ALTER TRIGGER [dbo].[tinsertV86]

ON [dbo].[TBL_LiveData_Bit]

AFTER UPDATE

AS

IF EXISTS (SELECT *

FROM inserted i

JOIN deleted d ON i.ConfigID...

thank your for your answer , zes thats the problem i didnt know yher should i set the condition fo fire the trigger , where exactly ? after the "after...

the problem is that i created this trigger and i wanted that every time that a "start-value" change from false to true it insert a new line on thetable ,...

thanks a lot , that was helpfull