How to restrict the data

• New persopn

  SSCarpal Tunnel

  Points: 4019

  More actions

  June 11, 2012 at 5:57 am

  #392479

  Hi

  Here i want to know some information about replication

  I want to blocks some rows in publisher those rows should not reflect in subscriber.

• Andrew G

  SSChampion

  Points: 12809

  More actions

  June 11, 2012 at 6:45 am

  #1499281

  You can filter at the publisher, see here:

  http://msdn.microsoft.com/en-us/library/ms151775(v=sql.105)

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  June 11, 2012 at 9:52 am

  #1499368

  Filtering is simple in replication using a where clause.

  You can only use dynamic filtering in merge replication. For example

  servername = hostname()