Publishing Stored Proc's in Transact Replication

• chinn

  SSCrazy

  Points: 2840

  More actions

  March 15, 2003 at 12:41 pm

  #159633

  Is there a way you can publish only few i.e not all the sp's which are the publication database to be published at the subscriber,

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 17, 2003 at 10:18 am

  #451236

  You can select wich sp to replicate to the subscribers.

  I would suggest that you create multiple publications in a test server, and check all the posibilities of transactional replication.

  You can select with sp to replicate, and also, when to replicate the schema of the sp.