It would help to know what makes you think that it doesn't work anymore. Error messages maybe?

Verify that your database's compatibility is 7.0 or up. Since 6.5 didn't have the TOP clause, if the database's compatibility mode has been set to 6.5, you'll get an error. Check out sp_dbcmptlevel in the BOL.

-Mike


>I have a database that all of a sudden doesn't want to perform any queries with the TOP clause. For example, following code used to work but now it doesn't.
>
>SELECT TOP 1 * FROM ListOrder
>
>Anyone know what's going on? TIA.