Transactional Replication with Read-Only Subscribers

• Tsql-561486

  SSC Eights!

  Points: 821

  More actions

  February 4, 2009 at 8:24 am

  #199439

  Hi

  Can anyone let me know how to configure Transactional Replication with Read-Only Subscribers.

  I am not clear how to set a read only subscriber.

  Please help.

• Mike_D

  Hall of Fame

  Points: 3295

  More actions

  February 5, 2009 at 4:46 am

  #938718

  Read-Only is the default. The procedure sp_addsubscription accepts an @update_mode parameter which controls the setting.

  Mike