To touch upon an age-old subject:

Can a feature be added to enable one to specify the maximum number of rows
to be returned by a query. I know that this can be done with a SP, but
using a SP for prohibits the use of a dynamic SQL query from a client where
the client will specify the columns, WHERE clause, etc.

I don't know if this is patr of the SQL standard though...

Thanks