Timeline for Replicating Triggers
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 5, 2022 at 8:01 | history | edited | Glorfindel | CC BY-SA 4.0 |
broken link fixed, cf. https://meta.stackoverflow.com/a/406565/4751173
|
| Jun 7, 2012 at 23:10 | vote | accept | peter | ||
| Jun 7, 2012 at 23:10 | vote | accept | peter | ||
| Jun 7, 2012 at 23:10 | |||||
| Jun 7, 2012 at 23:05 | comment | added | peter | I understand the error message above now. My identity column in the Audit table was set as NOT FOR REPLICATION and the merge agent was running the trigger (the second time the trigger would run) and trying to insert into the audit table without specifying the identity column value. The merge agent can't at that point create a new identity column value. | |
| Jun 7, 2012 at 23:04 | comment | added | peter | That's the fault of my thinking. The first impression I got was 'NOT FOR REPLICATION' meant the trigger wouldn't be propogated to the subscribers. | |
| Jun 7, 2012 at 22:31 | history | answered | Brandon Williams | CC BY-SA 3.0 |