missing Replication-filter-procedure from publication

Question

Hi Guys

Any idea as to why my Replication-filter-procedures have gone missing from my publications.
The Replication-filter-procedures are missing from sys.objects table but they exist in FILTER ROWS in Publication Properties.
If they exist as I have mentioned in FILTER ROWS in Publication Properties, does reinitializing the publication insert them back in sys.objects

Answer 1

Hi @kK-2020 ,

Replication Filter Procedure is also named as Replication system stored procedures, you could accomplish one-time task by using them as a method. When you set up a replication, you could query them from the system table "sys.objects". For example, sp_articlefilter, which is one of the such procedures. Refer to MS document Replication Stored Procedures.

How did you add row filter in replication? Using SSMS UI or sp_articlefilter procedure? Did you try to using sp_articlefilter (Transact-SQL), then check the result from sys.objects. And did the filter works well in replication?

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".