Is trigger enabled if service is restarted?

• Ashwin M N

  Hall of Fame

  Points: 3668

  More actions

  April 30, 2008 at 2:27 am

  #189829

  I have disabled a trigger on a particular table.Will the trigger be enabled if the the sql server service is restarted.

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  April 30, 2008 at 2:32 am

  #808853

  Hi

  I dont think the trigger will be enabled when sql server service is restarted.

  "Keep Trying"

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 30, 2008 at 2:40 am

  #808859

  [font="Verdana"]

  Ashwin M N (4/30/2008)

  ---

  I have disabled a trigger on a particular table.Will the trigger be enabled if the the sql server service is restarted.

  You need to enable the Trigger manually to fire.[/font]

  MH-09-AM-8694