[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5725) SqlServerDialect should support SQL 2000 which does not support the row_number function

SqlServerDialect should support SQL 2000 which does not support the row_number function --------------------------------------------------------------------------------------- Key: HHH-5725 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5725 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.0 Reporter: Yoryos Valotassios As a fix to HHH-2655 a patch has been applied to SQLServerDialect that make use of the row_number function for paged results. As I can see from the comments of SQLServerDialect, this dialect should be fine for sql server 2000, but sql server 2000 does not support row_number function. There should be a new dialect that extends the SQLServerDialect one which will add support for paged results throw the row_number function.