How can you `UPDATE` an SQL Server table without triggering the UPDATE trigger

Question

I have an update trigger that updates some important status fields in a table tblCurrent.
When I first upload the daily batch of records into tblCurrent (circa 10K records), I perform some UPDATEs via three separate stored procedures when these are first uploaded and only then. How can I prevent the update trigger from running during these three initial UPDATEs?

Answer 1

You could temporary disable triggers for the table and then enable them back. MSDN article.

DISABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL } ON { object_name | DATABASE | ALL SERVER } [ ; ]

ENABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL } ON { object_name | DATABASE | ALL SERVER } [ ; ]

For example to disable all triggers for given table run following statement:

DISABLE TRIGGER ALL ON tblCurrent;