I am not sure about that because while users implement SELECT from subscription database, publisher replicates data to the subscription server meaning that INSERT and UPDATE also take place (which are done with the logreader agent) in subscription database along with SELECT. The purpose of asking this question is that I am thinking about implementing indexed view on my subscription database. As we know, indexed view is a great choice for read-only database as we do not UPDATE/INSERT/DELETE rows from those tables.

  • You cannot set a Subscription database to be read-only within a Replication. Database security change to read-only might help in your case. – CR241 Nov 19 at 0:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.