>Hi,
>
>I have a client with a database that has a trigger that should run when records get inserted, updated or deleted. The trigger updates the quantity on hand of a stock item in another table.
>
>The trigger runs fine on my database and all my other clients' but is apparently not running on just this one database.
>
>I checked that the triggers are enabled and that the code is exactly the same as on my working database.
>
>Is there a way that I can debug this to see if the trigger is actually running?
>
>This is a VFP front end updating a SQL Server 2012 database.
The problem was a bug in my trigger code that was hidden in certain instances by a coincidence of data values.