Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-20 : 08:23:12
|
| Mala writes "Hi,How can I set subscriber in transactional replication as read only database. Regards,Mala" |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-10-20 : 08:43:12
|
| You cannot explicitly mark the subscribing database as 'read only', because the replication agents need to be able to write to this database.You need to implement the 'logical read-only' database using database permissions, and make sure no user or application writes to this database.There are workarounds though, like having triggers on the tables, that rollback all changes done by users other than replication agents. Look into using the 'NOT FOR REPLICATION' property of triggers.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
Transactional Replication