Alter disabled trigger in SQL Server without enabling it It seems like triggers get enabled automatically after altering them. How can I alter triggers programmatically without changing their enabled/disabled status?

Code to reproduce:

create trigger trig
on MyTable
after insert
as select 0

go

disable trigger trig on MyTable

go

select is_disabled from sys.triggers where name = 'trig'

go

alter trigger trig
on MyTable
after insert
as select 1

go

select is_disabled from sys.triggers where name = 'trig'
You can't. You just need to disable it again. There is no ALTER TRIGGER syntax that prevents this.

The disable trigger topic explicitly calls out that 


  Changing the trigger by using the ALTER TRIGGER statement enables the
  trigger.