SQL Server 2k does not appear to support the LIMIT clause.
This should seek to the 10th record in the result and return only five records:
SELECT fields FROM table LIMIT 10,5;
How is that accomplished in SQL Server? "TOP" appears to support only the second part of the LIMIT clause, "return only X records".