Triggers View

SELECT * FROM sys.server_triggers

select * from sys.triggers


disable trigger trg_create_table_with_pk on database
enable trigger trg_create_table_with_pk on database

disable trigger connection_limit_trigger on all server
enable trigger connection_limit_trigger on all server

DISABLE TRIGGER HumanResources.dEmployee ON HumanResources.Employee;
ENABLE TRIGGER HumanResources.dEmployee ON HumanResources.Employee;