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

__________________
cheers,
debsoft

I would set up SQL Profiler/Trace to see what commands are getting executed by the .NET application. You could also use Red Gate's Reflector to see the actual code (unless it's deliberately obfuscated). It maybe that the trigger is deliberately disabled although that seems strange.

__________________
Joe
http://joe.fawcett.name/

Possibly... the first thing to do would be to check the trigger code (or course). Would you post the trigger code, please?

__________________
--Jeff Moden