IsNull actually I have no idea how you are getting into TopLimitHandler, because the Hibernate supplied SQL Server Dialects all use SQLServer2005LimitHandler.

Is this a custom Dialect?