title: Nhibernate got errors while changing dialect from SQL Server 2008 to 2000
body: <p>My projects are based on ASP.NET MVC4 + SPRING.NET 2.0 + NHIBERNATE 3.3</p>
  
  <p>My developing database is on SQL Server 2008. All works fine in it.</p>
  
  <p>But when I upload published project to production environment using SQé Server 2000, opening any page show errors:</p>
  
  <blockquote>
    <p>ROW_NUMBERS not found</p>
  </blockquote>
  
  <p>and</p>
  
  <blockquote>
    <p>Line 1:Syntax Error near '(' </p>
  </blockquote>
  
  <p>and I had changed my database config to <code>NHibernate.Dialect.MsSql2000Dialect</code></p>