SQL Server 2005 - 'RANK' is not a recognized function name.

[Kev37Barrie]

Hello

I am getting the following error -

'RANK' is not a recognized function name.

when trying to run -

SELECT RANK() OVER (ORDER BY application_id, applicant) AS id, contact_id, applicant, contact_type, application_id
FROM   dbo.vwContactWithSyntheticList
 

This works on one server, but not the other. The only difference is that one server is Windows 2003 Server (where it works) and the other is Windows 2000 Server (where it doesn't work).

Both servers are running SQL Server 2005 on Microsoft SQL Server Management Studio 9.00.1399.00

Any ideas?

Thanks

Kevin.

[Kev37Barrie]

Ignore this, me, being thick!!

Looking at the wrong instance...d'oh!!