>>>>>>>>>>>>>>>>>>
>Yes it Works, i just found the solution to the Top Clause, in Q260526 It describes the problem if SQL Server 7.0 database is set to 6.5 Compatibility The TOP clause is not supported.
>
>Thanks, it all woks with the TOP Clause now !!
>>>>>>>>>>>>>>>>>>
>
>Thanks for the heads up on the knowledge base article.
>>>>>>>>>>>>>>>>>>
>
>Interesting article. Something I did not know. I took the liberty to add it to the Wiki:
>http://fox.wikis.com/wc.dll?Wiki~KnowledgeBaseWatch~softwareEng

Alex,

Do you know of any reasons for using 6.5 compatibility mode?