Trigger not firing in SQL Server 2000

[debsoft75]

Hi All, I have created a Insert Trigger and a Update Trigger on a table in a database. 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

[Abhishek Sur]

This is weird.. If any insert operation is made trigger gets fired automatically. Open SQL Server profiler -> and check what exactly is running from inside that application. It must be invoking some insert statement on the database. :)

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.