There ware many changes to SQLServerDialect* after this was fixed, take a look at source at https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/SQLServerDialect.java Don't know which one broke it for 2000. best way to try to fix it and sent PR hibernate-orm project
There ware many changes to SQLServerDialect* after this was fixed, take a look at source at https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/SQLServerDialect.java
Don't know which one broke it for 2000. best way to try to fix it and sent PR hibernate-orm project