SQL Server Performance Forum – Threads Archive
Table Trigger is not firing when importing data
Dear AllI have trigger build on a table (ON INSERT trigger)
If I tried to use normal insert statements, the trigger is firing but if I tried to import data from MS EXCEL sheet, the trigger is not firing when inserting new record Is there any resolution for this problem? Thanks in advance Regards
Ahmed Gomaa
[email protected]
How are you importing the data? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Using the SQL Server DTS Wizard
Monitor the event using PROFILER for the trigger specification. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>