It is possible to manually alter the filter_clause at sysarticles?

• ricardo_chicas

  SSCertifiable

  Points: 5024

  More actions

  May 13, 2014 at 12:25 am

  #293099

  Hello all

  I have a huge replication that takes days to be generated, many sources and hundreds of millions of rows

  It looks like the replication have a bug because it is saying the it is unable to execute sp_replcmds due to a filter, filter that I execute manually and works perfectly

  what I want to do is change the filter at sysarticles as to avoid to have to rebuild the whole replication, that will be a disaster

  Any help will be very appreciated

  my env is using sql server 2008 r2

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  May 13, 2014 at 2:47 am

  #1712937

  There's no way of altering the filter. Are you sure this is the solution to your problem? Whats the exact error?

  This is what I would do if its your solution:

  Ensure no activity on the publication database

  Drop the subscription

  Drop the existing filter

  Re-add the filter (& view)

  Re-add the subscription with @synctype=none

  Clean up the subscriber table manually if needed

  The last two steps could be switched

• ricardo_chicas

  SSCertifiable

  Points: 5024

  More actions

  May 13, 2014 at 7:13 am

  #1713022

  Hi this is the exact error

  Execution of filter stored procedure 319272188 failed. See the SQL Server errorlog for more information. (Source: MSSQLServer, Error number: 18764)

  Get help: http://help/18764

  The said filter works and it also has been working for years at the same replication it is just now that it started to fail

  I want to remove a part of the filter as to load less rows