Using trigger in stored procedure

• eletuw

  SSCrazy

  Points: 2464

  More actions

  August 22, 2002 at 9:53 am

  #78857

  How do I disable a trigger inside a stored procedure, perform some actions and re-enable the trigger afterwards. This is becuase you can't create a trigger within a stored proceudre. I can't drop and re-create the trigger within the stored procedure.

• GRN

  Hall of Fame

  Points: 3260

  More actions

  August 23, 2002 at 3:13 am

  #435161

  run this to disable a trigger

  ALTER TABLE <TableName>

  DISABLE TRIGGER <TriggerName>

  and this to enable it

  ALTER TABLE <TableName>

  ENABLE TRIGGER <TriggerName>

• eletuw

  SSCrazy

  Points: 2464

  More actions

  August 23, 2002 at 7:41 am

  #435199

  Thanks for your help. I will give it a try.