Read Only

If I change my Replicated db to Read Only, will this result in any adverse effects for Replicating to this db?
I don't want users to have any access to the db other than reporting, and I read on sql server performance:
"If you have a database that acts as a datamart or data warehouse, set the "read only" database option to true. This will turn off locking and greatly speed queries against the data."
Thoughts anyone?
Thanx!
JLS,
for replication I think you'll have to achieve the same effect (protecting the database) using permissions. Alternatively you could use this option and 'undo' it in the replication synchronization job as a custom step.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||nice idea. however. readonly is readonly and replication i think is not an
excuse
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"JLS" wrote:

> If I change my Replicated db to Read Only, will this result in any adverse effects for Replicating to this db?
> I don't want users to have any access to the db other than reporting, and I read on sql server performance:
> "If you have a database that acts as a datamart or data warehouse, set the "read only" database option to true. This will turn off locking and greatly speed queries against the data."
> Thoughts anyone?
> Thanx!
>