>>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.
>
>If the code is same, maybe the data not ("unknown value", null value, etc.)
>You can debug trigger in MS SQL Management Studio.
>You can insert/update/delete master table in MS SQL Management Studio.
>You can use MS SQL profiler for checking what lines of trigger are runned.
>
>
Thanks, I am trying your suggestion of using the SQL Profiler. I am not seeing how to see what lines of the trigger get run. I've attached a screen shot showing what I am seeing.
Appreciate any more assistance you can offer.