Sergiy you have peeked my interest. I am sure I am walking into something here, but let me do it any way.

If I do not update a table column by...

I have figured out the issue. I changed the trigger.

CREATE TRIGGER trg_#1 ON dbo.table1

FOR UPDATE

AS

IF UPDATE( dtmDateApproved)

BEGIN

INSERT INTO tbl_table2(table1ID)

SELECT DISTINCT table1ID

...

I did not think about that. I ran sp_helptrigger on my table. It returned only 2 triggers.

trg_table1_RunNightQAdbo11110

trg_#1dbo10010

the trg_table1_RunNightQA trigger is also firing twice. I looked and basically it is...