[eluser]OverZealous[/eluser] @tdktank59
If you look within the CI-provided MS SQL code (system/database/drivers/mssql/mssql_driver.php), you will see that they have a work around that lets you still use the built-in AR limit method, but generate the correct query.