TOP keyword no longer works 1

[ElectricEel]

The TOP keyword no longer works on one specific database. It gives me an "Incorrect Syntax" error whenever I use it. It works on every table but one.

Also, in EM, the "Return Top.." menu item is not enabled.


Help PLEASE!

TIA.

 

[karluk]

I would check your database properties, options tab to make sure that the database compatibility level is at least 70.

 

[ElectricEel]

Thanks for pointing me in the right direction. EM's properties said it was 7.0 compatible, however it's not like Microsost has never been wrong before...

I EXEC'd sp_dbcmptlevel 'TableName', 70 and viola! TOP works.

Aloha

Neil