Dsable / Enable All Triggers in a table from SQL Server

to Enable

ALTER

 

TABLE <tablename> ENABLE TRIGGER ALLto Disable

ALTER

 

TABLE <tablename> DISABLE TRIGGER ALL