We found that the trigger on a table didn't work after we've delete all
records from that table. The trigger works fine before and it just seems
disappeared. If we re-create the trigger again, the problem solved.

We also found nothing special from the database errorlog and DBCC.

Any ideas?

Thanks,
Gordon