Unable to remove data sync group - always provisioning

Answered Unable to remove data sync group - always provisioning

  • 2012年3月2日 上午 03:24
     
     

    I created a Data Sync Group. One of the tables has a couple of computed column. Turns out this isn't supported (so why did it let me do it?) so in the log viewer I see lots of errors (see below for example text).
    So now I need to remove the sync but it always seems to be "Provisioning" and wont allow me to remove it.

    This means that I can't add another (corrected) Sync because the DB is already "provisioning".

    How can i remove this Sync?

    Thanks

    Mark

    Server id: c7b688c8-c893-4318-ad17-3a5c3efb4242
    Region: North Central US
    Time / Date: 2-March-2012 03:16 GMT
    Tracing Id: 7d212627-da7d-42ad-b398-af1a152a644f


    Error text:
    Database provisioning failed with the exception "The column "DepartureBest" cannot be modified because it is either a computed column or is the result of a UNION operator.
    The column "ArrivalBest" 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 "DepartureBest" cannot be modified because it is either a computed column or is the result of a UNION operator. SqlError Number:271, Message: The column "ArrivalBest" cannot be modified because it is either a computed column or is the result of a UNION operator.

所有回覆