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
How different is the LIMIT implementation different from SQL Server 05
and 08?
I fear that since ZF1 is approaching its final minor version and that
there are far fewer people running 2000 in production over 2005, it
might night make sense for this in ZF1.
-ralph
On 2/10/12 10:19 AM,