Sort date by Desc doesn't work in SQL Server 2005

[Jose]

I have an application access 2003 (adp) as front end and SQL server 2005 as
backend.

My application worked well with sql server 2000 as backend, I migrated to
sql server 2005 and I found the following error:

I have a view:

SELECT TOP (100) PERCENT dDate, Eqmt, EqmtDate, HrsMeterPrev
FROM dbo.B3_Eqmt
ORDER BY dDate DESC

If I open this view over management studio, the Date sort is correct (DESC).
If I open this view from access the sort is worng is asc and not desc.
I re-create a new view and the problem still existing

Any suggestions to fix this issue?

There are another erros after migrating sql server 2000 to sql server 2005?

Thanks a lot
Jose

 

[Sylvain Lafontaine]

Per the sql standard, ORDER BY statement are not part of a view and this
problem (?) has been corrected in SQL-Server 2005.

In your case, add the sorting on the ADP side or enclose your view in a
select statement with an order by or replace TOP (100) PERCENT with TOP
2000000000.

 

[Jose]

Thans Sylvan,

It works but is not frindly to add top 100000 or more.
In Sql Server 2000 I nver found this problem