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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Can a trigger fire during Import Wizard?

Author  Topic 

michaelxvo
Starting Member

47 Posts

Posted - 2006-11-30 : 21:02:28
Hello,
I plan to write a trigger (after insert) and I would like it to fire while importing data from a text file.
I read MS documentation and it says trigger will not fire on bulk insert operations
I wonder if trigger will fire if I use Import and Export Wizard and import data from a text file?

Thank you
   

- Advertisement -