Select top 10

Hej!

Jeg har følgende SQL string:
SELECT TOP 10 * from srv order by nowcount desc


Den kommer med fejlen:
ADODB.Recordset.1 error '80004005'

SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '10 * from srv order by nowcount desc' at line 1


Hvorfor det??