SQL Server 2000
I have an after update trigger in one of my table. it works fine when EXECuting a stored proc from Query Analyzer that updates the table. The prob is that the trigger does not fire when running the SP from my VB.net code using SqlComm.ExecuteNonQuery.
Any idea how to fire the trigger when running my SP from vb.NET?