Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Testing/debugging filter clauses RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    '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