>>>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.
Check to see if the trigger is disabled:
SELECT name, is_disabled FROM sys.triggers
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.