Application doesn't start on MSSQL 2005

[GoogleCodeExporter]

What steps will reproduce the problem?
1. svn checkout
2. create web.config , configure to use mssql 2005. i.e:

  <activerecord isWeb="true">
    <config>
      <add key="hibernate.connection.driver_class" 
value="NHibernate.Driver.SqlClientDriver"/>
      <add key="hibernate.dialect" 
value="NHibernate.Dialect.MsSql2005Dialect"/>
      <add key="hibernate.connection.provider" 
value="NHibernate.Connection.DriverConnectionProvider"/>
      <add key="hibernate.connection.connection_string" value="Data 
Source=BARTEK-2K3;Initial Catalog=Stacked;Integrated Security=True"/>
    </config>
  </activerecord>

3. Start

What is the expected output? What do you see instead?

Expected clean homepage. 

Got exception: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM 
and 12/31/9999 11:59:59 PM.
Line 35:             oper.FriendlyName = "default";
Line 36:             oper.IsAdmin = true;
Line 37:             oper.Create();
Line 38:         }
Line 39:     }
Source File: c:\prj\!ro\stacked-read-only\WebSite\Global.asax    Line: 37 

After fixing this exception by using Nullable<DateTime> got another 
exception:

Incorrect syntax near 'limit'.
Incorrect syntax near the keyword 'order'.
Line 316:                        return retVal.Execute();
Source File: c:\prj\!ro\stacked-read-only\WebSite\App_Code\QuizItem.cs    

What version of the product are you using? On what operating system?

svn rev 74, MSSQL 2005

Please provide any additional information below.

1. http://rkse.blogspot.com/2007/06/when-it-comes-to-nhibernate-dates-
are.html

2. LIMIT is not supported on MSSQL, lets use MAX

Original issue reported on code.google.com by e...@devel4.net on 3 Jan 2009 at 12:26

[GoogleCodeExporter]

Patch included

Original comment by e...@devel4.net on 3 Jan 2009 at 12:27

Attachments:

• sql2005.patch

[GoogleCodeExporter]

Original comment by phamthie...@gmail.com on 16 Apr 2009 at 10:56

Attachments:

• con1newdc9.gif