• In SQL Server 2008 in the first statement (SET TRANSACTION)

    ISOLATIONLEVEL should be

    ISOLATION LEVEL

    Herman