none
Trying to set up synchronization between two SQL Azure databases

    Question

  • Hi,

    I tried to use the Sync feature on a database on North Europe datacenter to two other datacenters.

    The sync hub was correctly configured, but I get this error on provisionning phase:

    Database provisioning failed with the exception "The column "PourcentageRep" cannot be modified because it is either a computed column or is the result of a UNION operator.

    Inner exception: SqlException Error Code: -2146232060 - SqlError Number:271, Message: The column "PourcentageRep" cannot be modified because it is either a computed column or is the result of a UNION operator. 
    "

    This column is indeed part of a view and the result of an union operator.

    Can you give me some advices on how to handle this error please ?

    Thanks.


    R.

    Thursday, May 17, 2012 10:24 AM

Answers

All replies