trigger

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  July 26, 2006 at 8:22 am

  #114818

  How can I disable trigger, I dont want that to delete coz I may use it at some point of time. I want the trigger to be on my table but shud not fire at this point of time.

• apinnelli

  Mr or Mrs. 500

  Points: 555

  More actions

  July 26, 2006 at 8:35 am

  #651645

  Hi, try this to disable

  ALTER TABLE samp_test DISABLE TRIGGER samp_test_update_trigger

  and this to enable

  ALTER TABLE samp_test ENABLE TRIGGER samp_test_update_trigger

  PinAnt

• Bhushan

  Default port

  Points: 1427

  More actions

  July 27, 2006 at 1:42 pm

  #651996

  if u are using SQL 2005 then

  DISABLE TRIGGER <> ON <>

  ENABLE TRIGGER <> ON <>