title: Can't reload our TFS analysis cube due to snapshot isolation
body: <p>We're trying to reload the TFS 2010 SSAS cube, but when the warehouse is processing, we get an exception in the log.  It is important to note that the cube does not fail completely, but loads incompletely.  For example, we have data up to June 2011, but not beyond.</p>
  
  <blockquote>
    <p>Microsoft.TeamFoundation.Server.WarehouseException: OLE DB error: OLE
    DB or ODBC error: Snapshot isolation transaction failed in database
    'Tfs_Warehouse' because the object accessed by the statement has been
    modified by a DDL statement in another concurrent transaction since
    the start of this transaction. It is disallowed because the metadata
    is not versioned. A concurrent update to metadata can lead to
    inconsistency if mixed with snapshot isolation.; 42000</p>
  </blockquote>
  
  <p>This is our future production system, and contains data migrated over from a TFS 2008 system.  The database size of the version control repository is close to 200GB, so we're dealing with a relatively large instance of TFS.</p>
  
  <p>We could remove snapshot isolation from our warehouse, but I'm a little concerned about doing this, as I can't find anything that tells me whether snapshot isolation is required on the TFS_Warehouse database.   Any insight would be appreciated.</p>