Merge replication join filter error

Discussion in 'Replication' started by Matić Željko, Oct 4, 2017.

  1. Matić Željko

    Matić Željko

    Oct 4, 2017
    Likes Received:
    I'm creating join filter based on identity column in one table (int) and integre column in another. In SQL 2008 strange error appeare

    Msg 22518, Level 16, State 1, Procedure sp_addmergefilter, Line 283
    Cannot use column of type image, ntext, xml, CLR type, varchar(max), nvarchar(max), or varbinary(max) in a subset or join filter for article: '[DNEVNO IZVJESCE - DOPUNSKI PROJEKT - PROGRAM]'.

    But in article exists columns of that type but not in join.

    This join filter I have in SQL 2000 and there it was applied without problems

    Thanks in advance
    Matić Željko, Oct 4, 2017
    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.