Double check the "Compatibility level" of your database.

sp_dbcmptlevel @dbname = 'MyDatabaseName'

If it shows compatibility level less than 80, then you should either update Compatibility level to be 80

sp_dbcmptlevel @dbname = 'MyDatabaseName', @new_cmptlevel = 80

or use

SET ROWCOUNT { number | @number_var } 

in order to limit the number of records returned.


Cheers,

Zoran

>sqlserver 2000 that i use doesn't recognize the TOP clauseof the select 200 * from ...
>
>in the help file of sqlserver, it said that TOP is a reserved word and it must not be used.
>
>is there a another way to select the n top records ?