TOP CLAUSE not working in queries and views

I had to convert a database from VFP into SQL 2000.  I have a primary key I
have added, plus I have properly indexed the table as well.  Unfortunately,
I cannot create a query that supports the TOP clause.  SQL Server keeps
returning "Incorrect syntax near '100'"  The user DBO has permissions to
everything.  I have created a view in another database on the same server
and it seems to respond correctly.

SELECT
TOP 100 PERCENT
*
FROM
TableA

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"John Cosmas" <johncosmas@charter.net> wrote in message
news:zAVGe.2526$5B2.990@fe04.lga...
>I had to convert a database from VFP into SQL 2000.  I have a primary key I
> have added, plus I have properly indexed the table as well.
> Unfortunately,
> I cannot create a query that supports the TOP clause.  SQL Server keeps
> returning "Incorrect syntax near '100'"  The user DBO has permissions to
> everything.  I have created a view in another database on the same server
> and it seems to respond correctly.
>

Check to be sure the server is not in 6.5 compatibility mode.

--
Andrew J. Kelly  SQL MVP


"John Cosmas" <johncosmas@charter.net> wrote in message
news:zAVGe.2526$5B2.990@fe04.lga...
>I had to convert a database from VFP into SQL 2000.  I have a primary key I
> have added, plus I have properly indexed the table as well.
> Unfortunately,
> I cannot create a query that supports the TOP clause.  SQL Server keeps
> returning "Incorrect syntax near '100'"  The user DBO has permissions to
> everything.  I have created a view in another database on the same server
> and it seems to respond correctly.
>