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

[AndrewD]

Hi.

After creation 2nd record in any module I can see in the List view only one record. In the pagination string I see (1 - 1 of 2). I click 'Next' button and get error "SQL Error : 'ROW_NUMBER' is not a recognized function name". I found this thread: http://sugarcrm.com/forums/showthread.php?t=16880. Hear are prints of $sql and $newSQL:

 $sql=
SELECT  contacts.id , ISNULL(contacts.first_name,'') + ' ' + ISNULL(contacts.last_name,'') as name, contacts.first_name , contacts.last_name , contacts.salutation , contacts.title  , accounts.name account_name, jtl0.account_id account_id, contacts.email1 , contacts.phone_work  , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod, contacts.assigned_user_id  FROM contacts   LEFT JOIN  accounts_contacts jtl0 ON contacts.id=jtl0.contact_id  AND jtl0.deleted=0
 LEFT JOIN  accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0
 AND accounts.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= contacts.assigned_user_id AND jt1.deleted=0
 AND jt1.deleted=0 where contacts.deleted=0
 
$newSQL=
SELECT  ROW_NUMBER() OVER (ORDER BY contacts.id) AS row_number,  contacts.id , ISNULL(contacts.first_name,'') + ' ' + ISNULL(contacts.last_name,'') as name, contacts.first_name , contacts.last_name , contacts.salutation , contacts.title  , accounts.name account_name, jtl0.account_id account_id, contacts.email1 , contacts.phone_work  , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod, contacts.assigned_user_id  FROM contacts   LEFT JOIN  accounts_contacts jtl0 ON contacts.id=jtl0.contact_id  AND jtl0.deleted=0
 LEFT JOIN  accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0
 AND accounts.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= contacts.assigned_user_id AND jt1.deleted=0
 AND jt1.deleted=0 where contacts.deleted=0
                             ) AS a
                             WHERE row_number > 1 
  

SugarOS 4.5f is installed on Windows 2003 Advanced Server (SP1) machine with PHP 4.4.2.
The DB is located on another machine with Windows Advanced Server 2000 (SP4) and MS SQL Advanced Server 2000 (SP3).

Hope to hear from you soon.

Thanks.