TOP statement does not work in SQL SELECT queries.

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

  • 10 Users Found This Useful
Was this answer helpful?

Related Articles

Where can I find documentation for ServerObject's AspMail component?

This documentation can be found at: http://www.serverobjects.com/products.html For...

How do I upload files through my web pages?

You can use Software Artisan's SAFileUP. This is an ASP component that allows you to upload files...

What is PageCounter and how do I use it?

About Page Counter PageCounter is an object that counts and displays the number of times a Web...

How do I setup Microsoft Outlook Express to read my e-mail?

Follow these steps: Open Microsoft Outlook Express. From the Tools menu, click...

How do I setup Netscape Messenger to read my e-mail?

Follow these steps: Open Netscape Navigator. Click the Edit menu and then click Preferences......