Boy Michael, you must be a genius. Although I'd already found compatibility setting to be the problem by before I read your post, you would of nailed it on the head.
Now, I would be even more impressed if you knew the idiot who changed this setting on my database. Thanks!
>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.
It's "my" world. You're just living in it.