• Interesting question. Of course there should be no need to hide the columns unless the existing apps are using "*" instead of "<columnlist>".

    Adding the extra columns with defaults may be very expensive, depending on the edition of SQL Server, so converting an existing table to be versioned could be painful.

    Tom