Closed ChristianTrolleMikkelsen closed 11 years ago
It is standard behaviour that BULK inserts do not fire triggers:
http://msdn.microsoft.com/en-us/library/ms187640(v=sql.105).aspx
However we REALLY need to be able to enable this.
Could you please make a modification which allows this. Something like EnableTriggersOnBulk = true or whatever you find more logical :).
Without it we need to do single inserts in a tx and its killing performance big time.
It is standard behaviour that BULK inserts do not fire triggers:
http://msdn.microsoft.com/en-us/library/ms187640(v=sql.105).aspx
However we REALLY need to be able to enable this.
Could you please make a modification which allows this. Something like EnableTriggersOnBulk = true or whatever you find more logical :).
Without it we need to do single inserts in a tx and its killing performance big time.