title: How to check if a column is being updated in an INSTEAD OF UPDATE Trigger
body: <p>I am making some tweaks to a legacy application built on SQL Server 2000, needless to say I only want to do the absolute minimum in the fear that it may just all fall apart.</p>
  
  <p>I have a large table of users, tbUsers, with a BIT flag for IsDeleted. I want to archive off all current and future IsDeleted = 1 user records into my archive table tbDeletedUsers. </p>
  
  <p>Moving the currently deleted users is straight forward, however I want a way to move any future users where the IsDeleted flag is set. I could use a standard AFTER trigger on the column however I plan to add some constraints to the tbUser table that would violate this, what I'd like is for my INSTEAD OF UPDATE trigger to fire and move the record to archive table instead?</p>
  
  <p>I guess my question is... is it possible to trigger an INSTEAD OF UPDATE trigger on the update of an individual column? This is what I have so far:</p>
  
  <pre><code> CREATE TRIGGER trg_ArchiveUsers
   INSTEAD OF UPDATE ON tbUsers
   AS 
      BEGIN
        ...
      END
   GO
  </code></pre>
  
  <p>If so an example (SQL 2000 compatible) would be much appreciated!</p>