Skip to Content

Former Member

May 19, 2015 Less than a 1 minute read

SQL Query to Retrieve Rep Subscription Where Clause

Follow RSS feed Like

0 Likes 945 Views 4 Comments

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

Alert Moderator

4 Comments

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

Mark A Parsons

May 19, 2015 at 3:21 pm

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.
- Like(0)
- Former Member Post author
  
  May 19, 2015 at 3:39 pm
  
  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
  - Like(0)
- Former Member
  
  May 21, 2015 at 12:52 pm
  
  Sounds like an excellent candidate for an “Ed Barlow” stored procedure IMO
  - Like(0)
  - Mark A Parsons
    
    May 21, 2015 at 4:55 pm
    
    FWIW, cutting-n-pasting the important parts from rs_subddl is relatively easy (as opposed to reinventing the wheel).
    Like(0)