thank-you, this has helped a lot.

Lastly, is there any way of seeing which row (primary key) is being updated and also the user_id updating?

thank-you kindly. this worked perfectly.

many thanks!!!

is there any way you can narrow the update to being a single column to a single value. I only want the trigger to run when column A is...

many thanks for you reply,

how do i get the trigger to show me what code what run to update it (i.e. stored proce)?

I was using

INSERT dbo.t_account_TriggerLog

SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)'),

but that...

hi, thanks for getting back to me.

I am trying to create a trigger that runs whenever a value in a specific column is updated to 0

how do i go...