Disable All Triggers in MS SQL Server Table

200 Reads Ms Sql

In MS SQL Server, run the code below to disable all TRIGGERs in a table.

ALTER TABLE {Table Name} DISABLE TRIGGER ALL
Ms Sql

You May Interest

Getting the Id of MS SQL Server Last Entered Record

Generating Random Letters in MS SQL

What is Data Collector in SQL Server ?

What is FILLFACTOR in SQL Server ?

What is the Bookmark Lookup and RID Lookup in SQL Server ?