Index: cpa/src/main/java/org/castor/cpa/persistence/sql/driver/SQLServerQueryExpression.java
===================================================================
--- cpa/src/main/java/org/castor/cpa/persistence/sql/driver/SQLServerQueryExpression.java	(revision 8135)
+++ cpa/src/main/java/org/castor/cpa/persistence/sql/driver/SQLServerQueryExpression.java	(working copy)
@@ -92,7 +92,7 @@
                         + _factory.quoteName(tableAlias));
             }
             if (lock) {
-                sql.append(" HOLDLOCK ");
+                sql.append(" WITH  (HOLDLOCK) ");
             }
             if (enumeration.hasMoreElements()) {
                 sql.append(JDBCSyntax.TABLE_SEPARATOR);