I'm using NHibernate 1.2.0 together with SQL Server 2005 Express, and it seems I have to specify fully qualified tablenames, like this:

"databasename.dbo.tablename"

when I create a query via the ISession.CreateSQLQuery() method. I only return scalar values (this is a reporting query), and the query works just fine when I specify full tablenames, but it is suboptimal as it makes the SQL depend upon a static databasename. Is there a way to correct this?

BTW: I do have the default_schema property setup correctly in the applications config.

What is the error message if you don't specify fully qualified names?

An unhandled exception of type 'NHibernate.ADOException' occurred in Dinumero.Data.dll

Additional information: could not execute query

The internal exception message I get is this: {"Ogiltigt objektnamn, 'XXX'."}

The error message is localized to Swedish, but it translates into "Invalid object name" where XXX is the tables name.
[/quote]