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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira