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 ?