none
Testing/debugging filter clauses RRS feed

  • Question

  • I am using SQLExpress

    I need to create some filters to select which records are sync'd

    How do I go about testing/debugging these filter clauses

    Can I execute them directly against my database from within SSMS?

    If I do so, how do I resolve [side] and [base]

    Thanks

    Howard Weiss


    Howard P. Weiss

    Wednesday, January 28, 2015 8:37 PM

Answers

  • 'base'  is the table you're trying to sync, 'side' is its tracking table.

    to see the filters in effect without actually running a sync, you can simply execute the  selectchanges sp substituting your filter value.

    • Marked as answer by hpweiss Thursday, January 29, 2015 2:11 PM
    Thursday, January 29, 2015 2:10 AM
    Moderator