Disable Enable Trigger SQL server for a table

sql-server triggers

use the following commands instead:

ALTER TABLE table_name DISABLE TRIGGER tr_nameALTER TABLE table_name ENABLE TRIGGER tr_name

sql-server triggers

The line before needs to end with a ; because in SQL DISABLE is not a keyword. For example:

BEGIN;DISABLE TRIGGER ...

sql-server triggers

As Mark mentioned, the previous statement should be ended in semi-colon. So you can use:

; DISABLE TRIGGER dbo.tr_name ON dbo.table_name

CodeHunter