SQL Server Performance

'read-only' subscribers

Discussion in 'Performance Tuning for SQL Server Replication' started by photura, Jun 26, 2006.

  1. photura New Member

    I need to make sure that our subscribers are 'read-only' so that users can only SELECT. My question is: If I set the database properties to 'read-only' will replication still be able to update the transactions?

    What's the easiest way to make sure the database is truly 'read-only?'

    Thanks.
  2. ndinakar Member

    I think you can configure publisher to use one account and allow only that user to have access to subscriber and not use that account in your application..

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************

Share This Page