I have database and specifically one table that is used for batch data transfer from another organization. With each run the table is truncated and rows are re-inserted. I want to handle that process in a more robust way, but I need to find out if the other system is doing its work in a single transaction with INSERT/VALUES or smaller individual statements. There is a substantial amount of data, so I don't want to capture the whole payload. The instance is SQL Server 2005 Standard.
What's the most lightweight way to capture details of this transfer?