active triggers

when i try the below code, i get 3 zero values

select distinct is_disabled from sys.triggers
GO
DISABLE Trigger ALL ON DATABASE
select distinct is_disabled from sys.triggers
GO
ENABLE Trigger ALL ON DATABASE
GO
select distinct is_disabled from sys.triggers

Select allOpen in new window

Are you trying to disable triggers on the database object or on table objects?

all tables

The code you provided disables all triggers for the Database object. I do not believe it disables the triggers for the tables. For that, I believe you would need to run DISABLE TRIGGER for each table.

works!