Skip to Content

Hi All,

I’m wondering if someone already develop a simple query based in replication metadata to retrieve the subscription where clause string.

If yes do you mind to shared it 😀

i have a proc to do do this but looks me super complex  to adapt to a  normal sql query 



To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Mark A Parsons

    NOTE: You should probably post these types of questions as a ‘discussion’ (not as a ‘document’).

    There is no ‘simple’ query for reverse engineering a subscription ‘where’ clause.

    Your best bet is to look at the source code for rs_helpsub and rs_subddl (called by rs_helpsub).  These should contain all the logic for reverse engineering the DDL (including the ‘where’ clause) for a given sub.

    1. Former Member Post author

      hi mark,

      thanks for feedback .

      the complexy of rs_subddl for where clauses is quite hard to make simple but i will try anyway.

      thanks for your feedback




Leave a Reply