ROW_NUMBER() in SQL 2005

[govind161986]

When I try to user ROW_NUMBER() function in sql server 2005, then I receive an error message stating "'ROW_NUMBE R' is not a recognized function name."

Please help.

Thanks.
Govind

[ck9663]

Can you post the whole T-SQL?

~~ CK

[nbiswas]

Check the database compatability level

exec sp_dbcmptlevel '<Name of db>'.

I think it will show 80 ( I presume that you had sql server 2000 instance at some point of time in your machine).

If this initial routine check is correct then do the following

- Right click on the database
- Go to properties
- In options change the compatibility level of your database to Sql Server 90

Hope this helps.