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?'

  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