The implementation of the limit() method relies on RowNumber() which did not exist prior to SQL Server 2005. SQL Server 2000 is pretty old by now, but there are still some databases running on that platform.
I wrote a custom db adapter to extend Zend_Db_Adapter_Sqlsrv that appears to fix this issue and make the method compatible with SQL Server 2000. If I enter a bug with the fix, would someone be interested in reviewing it for inclusion? (Also, I noticed when searching the issue tracker that there are component labels for several Zend_Db_Adapter_* classes but this was not one of them.) Andrew -- List: fw-general@lists.zend.com Info: http://framework.zend.com/archives Unsubscribe: fw-general-unsubscr...@lists.zend.com