• Try executing the whole statement at destination db:

    EXEC('MERGE ...') AT MYDBLINKNAME

    What is remote server? Sql server, oracle or something else?

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths