Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eddie
Starting Member
45 Posts |
 Posted - 2002-01-14 : 10:55:36
|
| I am using bulk insert to insert from a csv file to a table. I want to use an insert trigger to then take the data and move it to other tables but the trigger does not seem to fire. Is there a setting in the bulk insert I should specify to allow the trigger to fire or are triggers ignored on bulk inserts?Thanks,Eddie |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-01-14 : 10:59:51
|
| Triggers don't fire during a bulk insert because a bulk insert is a "non-logged" operation, which means the individual inserts are not recorded in the transaction log. This is one of the reasons why a bulk insert is fast |
 |
|
|
|
|
|
bulk insert..trigger..