Skip to Content
Actions

SQL Query to Retrieve Rep Subscription Where Clause

May 19, 2015 | 4 Views |
Follow

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 

Thanks

Joao

To report this post you need to login first.

4 Comments

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.

    (0) 
    1. Joao Pedro Costa 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

      regards

      Joao 

      (0) 

Leave a Reply