Seam's inbuilt pagination does works with MS SQL Server 2005?

[boy18nj]

My list screens are using EntityQuery API to access MS SQL Server 2005. Unfortunately, the pagination does works correct here. When I go to 2nd or 3rd page, sometimes it do shows duplicate row's.
Also in pagination queries it is firing top keyword for select queries, instead it should use

row_num

function supported in sql server 2005.
Let me know, if you are aware of pagination issue.

[boy18nj]

Anybody faced this issue?

[boy18nj]

So far I did not resolved my issue. But I did an workaround here, I increased the pagination size on server side to 2500 (this size is not used to display on UI), the total number of records are usually less than 2500. This is working fine.

It would be great to solve the pagination issue overall.