Hi
I am trying to setup a trigger on a database where the trigger fires off a store proc when there is an insert. For some reason, its working on a database in Dev and not on a database in QA.
the trigger is on an insert to a table, the trigger looks something like this
create trigger XXX
after Insert
SET XACT_ABORT OFF -- this so that when the proc attached to the trigger fails, insert it anyway
exec updatesomething
if @.@.error <> 0
exec createAudit
In dev, the row is inserted, but in QA the row is not. I did a trace, both have the SQL:BatchCompleted event of the insert sql statement, but in QA environment, the trace does not have the sql statement after exec updatesomething. it just stops at exec updatesomething.
I check the database settings to make sure there were the same, looks like they are, I do not know how to find out what is causing it to work in 1 database and not the other
thanks
Pauli
A few things to check for -
Make sure that the trigger exists and is enabled -- select objectproperty(object_id('dbo.XXX'), 'ExecIsTriggerDisabled') -- should return 0.
Your description above seems to imply that the trigger actually fired in the QA environment. If so, then it could be that there was an error causing the 'exec createAudit' to be skipped. You can check for this by looking for error events in the trace output.
Hope that helps you track it down.
