The TOP statement of SQL SELECT queries may not work if an SQL Server database has been migrated from version 6.5 to version 7.0 without setting the database mode to version 7.0.
See the Microsoft Support Knowledge Base article below for more details on this issue.
http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAEY06Q0S.ASP