Hi All,
I have created a Insert Trigger and a Update Trigger on a table in a database in SQL Server 2000. The Insert trigger will make an insert into another table whenever an insert happens on the table on which trigger is created.
Now an external application (developed in .NET and I have no source code access) makes an insert successfully in the table. But the trigger doesn't fire.
When I directly execute a insert script on the table from SQL Query Analyzer, then the trigger fires but when insert is done by the external application (.NET app) the trigger doesn't fire.
Can somebody help me out with this...I'm completely clueless as to why it is behaving this way.
Thanks
Debsoft
Loading
Master BillaPosted Sep 6, 2009, 10:41 PM
There is so many possible reasons,
take look here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107950
thank you
Jan MontanoPosted Sep 6, 2009, 8:33 PM
There are two reasons I could think of:
1. The external app is doing batch processing. As fas as I know, this is a known limitation and the trigger will not process successfully if batch processing is being done.
2. The external app has knowledge of the database (and has an admin account of the database). It disables the trigger before inserting records and enables it afterwards.