• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2764
  • Last Modified:

'ROW_NUMBER' is not a recognized function name. - SQL sever 2005

I installed SQL Server 2005 standard edition.

Try to run a query with the new function - 'ROW_NUMBER' and got this error statement

'ROW_NUMBER' is not a recognized function name.

Any ideas? Thx
0
musclejack
Asked:
musclejack
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi musclejack,
> ROW_NUMBER
ROW_NUMBER()

Cheers!
0
 
musclejackAuthor Commented:
That's what I did

SELECT Row, Name
FROM(
SELECT ROW_NUMBER() OVER (ORDER BY ProductID) AS Row, Name
FROM Product
) AS ProductsWithRowNumbers
WHERE Row >= 6 AND Row <= 10

0
 
Aneesh RetnakaranDatabase AdministratorCommented:
WITH ProductsWithRowNumbers AS
(
SELECT ROW_NUMBER() OVER (order by ProductID) AS Row, Name
FROM Product
)
SELECT *
FROM ProductsWithRowNumbers
WHERE Row between 5 and 10;
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
musclejackAuthor Commented:
I dont think it is syntax problem.  nevermind.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
I also think so, Do you have both sql server 2005 and 2000 installed on the same macine
0
 
musclejackAuthor Commented:
yes =)

yes, i have 2000 on it for a while and installed 2005 on top.  I googled search
never say I can't keep both in the same machine. what do you think? thx,
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
i think you installed 2005 withoout specifying a 'different' instance name ...hope my second post is also giving syntax error
0
 
imran_fastCommented:
hi musclejack,
did you restore database of sql 2000 on sql 2005 in that case it wont use 2005 functionality to do that you have to
right click you database go to properties in options change the compatibility level of your database to sql server 90
0
 
musclejackAuthor Commented:
Thanks aneeshattingal and imran_fast
0
 
DineshKammathCommented:
i have faced same problem before.

Now i have created new instnace name..

But not able to login now..



0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now