Downtime/Outage when altering a trigger

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  February 25, 2016 at 8:11 am

  #308418

  Is there any downtime involved when a DML trigger is altered?

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  February 25, 2016 at 8:17 am

  #1861084

  Downtime as in some (should be very short) locked system objects and operations on table yes.

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  February 25, 2016 at 8:23 am

  #1861089

  Thanks, This is a DML trigger after insert.