Is subscription database considered as read-only? RRS feed

  • Question

  • 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 distribution 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.
    Monday, November 18, 2019 12:57 PM


All replies