Problem with merge replication, join filter more than 128 characters.

Discussion in 'microsoft.public.sqlserver.replication' started by Ricardo Lima, May 26, 2008.

  1. Ricardo Lima

    Ricardo Lima Guest


    When it is run the snapshot agent, this error:

    The identifier that starts with 'PEDIDOS_FOR ) ))


    insert into
    dbo.MSmerge_ppmv_CD9300C631484C2D87355EC3B9635229 with (rowlock) (
    publication_nu' is too long. Maximum length is 128.

    An expression of non-boolean type specified in a contex

    This article have one join more than 128 characters, he problem would be

    The filters are in the format:

    [name_the_table].[name_the_field] = [name_the_table].[name_the_field]
    and [name_the_table].[name_the_field] = [name_the_table].[name_the_field]

    The filters are going to pass 128 characters..

    Ricardo Lima, May 26, 2008
    1. Advertisements

  2. How long is your longest article? There is a limitation on the article name
    Hilary Cotter, May 28, 2008
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.