• As usual, it depends.

    Replication uses locking like anything else. Even if you have a row filter on, unless that's a VERY small row filter (5000 rows or less), the possibility to want to upgrade to a table lock exists. Doesn't mean it will however, it will simply try.

    However, if your 3rd party apps have exclusive locks on rows your replication needs, there's nothing your locking techniques are going to fix for that unless you start doing some madness like read uncommitted or something equally painful... which I'm not even sure you CAN do in replication. I certainly hope not.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA