Forum Discussion
Solved
Unable to enable RCSI
We created our Azure SQL database few years ago and at that time RCSI was not a default setting. I am trying to enable RCSI now but unsuccessful. Database details: We have Azure SQL database (sing...
Yes, the replication was removed and reflected in the portal.
Instead of trying all the above steps, I just executed below one statement and RCSI is successfully enabled in primary database and successfully synced with secondary database as well.
ALTER DATABASE [DatabaseName] SET READ_COMMITTED_SNAPSHOT on WITH ROLLBACK IMMEDIATE
Yes, the replication was removed and reflected in the portal.
Instead of trying all the above steps, I just executed below one statement and RCSI is successfully enabled in primary database and successfully synced with secondary database as well.
ALTER DATABASE [DatabaseName] SET READ_COMMITTED_SNAPSHOT on WITH ROLLBACK IMMEDIATE