disable trigger

• kd11

  Hall of Fame

  Points: 3447

  More actions

  October 28, 2015 at 12:14 pm

  #399241

  When I run this : disable trigger tr_TBL1NAME on Name. It tells me that it doesn't exists or I don't have permissions.

  I do have permissions and I see it does exists because I ran " select name from sys.sysobjects where type = tr and name = "tr_TBL1NAME". Why can't I disable it?

• kd11

  Hall of Fame

  Points: 3447

  More actions

  October 28, 2015 at 12:40 pm

  #1836185

  Never mind, I use Alter table ..... to disable the trigger.