• For a single command (MERGE is a single command) you do not need "begin tran",

    each command starts implicit transaction, and commits/rollback implicitly, all the time (if not within larger transaction).

    Also, there is no "end tran" command, you probably meant "commit tran".

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