How to Update a table and prevent triggers from firing except disabling the Trigger

I have a table with 4 million images. This table is participating in Merge Replication. I have to update these 4 million images to set Image binary to null as these has been moved to a new table. The moment I will start update query, Merge replication triggers will fire and they will co开发者_如何学Gonsider that data for merge replication to subscribers and 4 million image rows will be transferred over the wire. I cannot disable merge triggers as this poses a data inconsistency issue.

I want a way so that merge triggers do not fire for this operation. Is there something like Bulk Insert for update as well?

---

You can use the sp_mergearticlecolumn stored procedure to drop that specific column from your subscription (temporarily if need be).

More information here: http://msdn.microsoft.com/en-us/library/ms188063.aspx