Search code examples
sql-serversql-server-2008triggersdatatrigger

MS Sql Server Triggers (2) executing at the same time: How do I catch what's causing it?

So I have 2 triggers on a table in my dbase. It's purpose is to log any data manipulation activities done by the user or by a third party import/export. The table where it saves it to have a datestamp which obviously marks when it was executed. For some reason, when this third party SSIS package writes a record to it it would trigger the triggers (as expected) but will have the exact same time. 1 record for inserting the record, and another record for updating the record. The problem is the datestamp is exactly the same up to the millisecond.

Any ideas on how I can track the cause of this? Should I be looking at the SSIS package? I dont think that would cause the 2 triggers tho.

Thanks for your time!

Solution

  • Try using SQL profiler to see what is being called. But my suspicion would be SSIS.