Last week we have seen this error when we have initialized new Subscriber from snapshot that was generated for transactional replication after published database schema was updated: ‘An error has occurred: Incorrect syntax near where’ This error occurred after about one hour of applying snapshot to subscribers database and caused…
In our scenario we have created transactional replica of our the production database to the staging machine where developers can prepare queries to be later executed in production. But in few days one of developers executed prepared DELETE statement directly against replica and the replication stopped to work with the…
We are using transactional replication to publish production data for the developers that they can test bugs and other stuff on the subscriber database with near-live data. From time to time they do a mistake and modify data on subscribers and the result is that replication is broken. In this…