Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Running any migration that alters existing replicated tables fails with the following error:

You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

Replication is transactional between two SQL Servers.

Have tried taking the scripts generated during the migration and executing in sql under same user and they work.

Is there a setting somewhere that may allow these updates to go through?

Visual Studio 2012 with EntityFramework 5.

share|improve this question
    
This was resolved with triggers grumpydba.blogspot.com/2011/01/… –  fyrplace Apr 16 at 14:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.