CODEWITHSUNDEEP
sqlazuretriggersazure-data-sync
daniel
daniel

Reputation: 35733

Azure Data Sync and Triggers

I use SQL Azure Data Sync to sync my remote Azure database with my local SQL database. Data Sync does create some addional tables on client and server and also adds delete, insert and update triggers to existing tables.

For what are these triggers? Can i delete them? I don't think so?

Problem now is that i can't edit data on server.

I get the error

The target table 'dbo.Corporation' of the DML statement cannot have any 
enabled triggers if the statement contains an OUTPUT clause without INTO clause.

Upvotes: 0

Views: 1877

Answers (1)

astaykov
astaykov

Reputation: 30868

The triggers are added by the Microsoft Sync Framework, which is being used for SQL Azure Data Sync. And, yes you can't delete them, because the SQL Azure Data Sync will stop working. It is not that easy to modify tables after they are provisioned. If you are adding columns check out this question. If it is something else, just try searching solution to your project tagged under Microsoft sync framework and not SQL Azure.

Upvotes: 1

Related Questions