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.