Version : 2.1.2

No problem with mapping files since they were created and tested using "from" and "select" statements.

Database is : SQL Server 2000
code--(If I try to execute this query using createSQLQuery() method it neither gives any exception nor creates the table. If I try it use java.sql methods table does get created.)

String CREATE_REPORT_TABLE = "begin " +
"create table transfer_report (" +
"ID int IDENTITY (1,1) PRIMARY KEY, " +
"name varchar(20) NOT NULL," +
"first_name varchar(7) NOT NULL," +
"last_name varchar(7) NOT NULL )" +
"end";
try{
Session con = ServiceLocator.getSessionFactory().openSession();
Debugger.debugMessage("In Test JSP","Before --");
try{
con.createSQLQuery (CREATE_REPORT_TABLE,null,TrasferReportVO.class);
}catch(Exception he){
Debugger.debugMessage("In Test JSP","Exception is raised: "+he);
}
Debugger.debugMessage("In Test JSP","After --");
con.close();
}catch(Exception he){
Debugger.debugMessage("In test JSP","Exception name - "+he);
}

you cannot do this, sqlquery is usable only if there are objects mapped with the tables you want to use.
take a look at schema export tool