Restriction: You cannot use any type of view in an ALTER TABLE statement. Restriction: You cannot use ALTER TABLE on a table that is accessed via an engine that does not support UPDATE processing.

One of the interesting new features in SQL Server 2008 is Change Data Capture ... update or delete statement then CDC is for you. For instance, you can use CDC in your incremental load package ...