The UpdateTables( ) method might commit changes in two transactions if a table is enabled for multi-tenancy and also has partition changes. The partition changes are applied in a separate transaction because the partitions (_storage-object records) do not exist in the database until the transaction that enables the table for multi-tenancy is completed.

Note that the only way to update partition changes together with the change to enable the table for multi-tenancy is through the Import( ) method on the ISchema object or on table collection objects. However, references to the Partitions collection property on these objects before the partitions exist in the database will throw an error.