Pagination doesn't work in mssql, help please :(

[eluser]Silencez[/eluser]
OMG!!

In mssql pagination doesn't work, I try the basic limit() function but it increases the amount of results instead of giving me the second, thrid, etc page...

I am not the first one with this problem that's why I thought there was no need for more details:

http://ellislab.com/forums/viewthread/62803/

I'd like a good active record hack, I dont know if anyone has something new and more effective to solvent this problem

Thank you