May 12, 2002 at 11:53 am
Is there any way to know whether the trigger set on a table has been fired or not?
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
May 12, 2002 at 1:05 pm
Trigger should always fire unless it has been disabled. I guess if you need to see it you could add a line that logged an entry to a table.
Andy
May 12, 2002 at 7:32 pm
Also to verify the trigger state this will help.
SELECT OBJECT_NAME(parent_obj) tablename, [name] triggername, (CASE WHEN (STATUS & 2048) = 2048 THEN 'Disabled' ELSE 'Enabled' END) state FROM sysobjects WHERE xtype = 'TR'
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply