Archive for the month June 2009

   Newer Entries »
Jun
08

ROW_NUMBER is not a recognized function name

I received this error while using ROW_NUMBER function for Paging in my project.
The root cause for the issue is
ROW_NUMBER function is not compatible with SQL 2000.
Though I was working on SQL 2005 but I was getting the same error.
After struggling a lot on the web, I realized that though I was using SQL 2005 interface, [...]

by admin on June 8th, 2009 in ASP.Net3 Comments »