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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2004-12-19 : 12:20:01
|
| I have triggers for each table, so when ever i insert a new record or update an existing record the trigger actually creates a copy of the same as a new record in the log tables.Now i am doing bul;k insert of the records when ever i do the bulk insert the trigger is not creating any records in the log table.I wrote the trigger on insert and on update, is there anything for onbulkinsert.Please help, I use the sqlxmlbulkload object to do bulkinsert from xml file to table.Thank you very much. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-19 : 13:06:56
|
| There is a FIRE_TRIGGERS flag for bulk insert.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
How to start a trigger on table with bulkinsert