SQL server 2000 - error - leads module - SQL Error : 'ROW_NUMBER' is not a recognized

[TakeMarket]

When we click on a lead in in the "lead module" in sugarcrm - we receive the error:

SQL Error : 'ROW_NUMBER' is not a recognized function name.

Any ideas on how to solve this issue?

The leads has just been imported and we receive the error on all subjects/leads except the first lead in the list.
Any help would be much appreciated!

Installed:

* Microsoft SQL server 2000 Enterprise SP3

* Windows 2003 server SP2

* php 5.2

* SugarCRM version: SugarOS-for-Microsoft-4.5.1h

Thanks a lot in advance your help!

[TakeMarket]

Ok - we kinda solved this by our selves, by some investigation - it's due to SugarCRM doesn't anmore support ms sql server 2000 - Only the 2005 version.

This opens a new question:

Best practices of migrating SugarCRm from MS sql server 2000 to 2005 - how to?

Thanks in advance..

(note: we have made new posting for this issue)