MSSQL Pagination Holly Grial?

[eluser]whobutsb[/eluser]
It definitely looks like the limit() method is causing the problem. I just tried this query in my model:
$this->db->select('contactID, firstname, lastname');
$this->db->limit($offset, $limit);
$query = $this->db->get('tblContact');

and it threw the error: Unsupported feature of the database platform you are using. when I added the limit command.

Possibly could you send me a sample of your code, maybe i'm writing it wrong.